Formula Help

[SRZ712]

Hi Guys,

I am slowly beginning to understand the logic for excel, ( I took a basic class in college, but for work I need to be way more advanced). Here is where I am hung up. I need a formula to produce this

[TABLE="width: 113"]
<colgroup><col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <tbody>[TR]
[TD="width: 151, bgcolor: transparent"]1-10 pages = 10.00 11+ @ 1.00 per page 100.00 Maximum
[/TD]
[/TR]
</tbody>[/TABLE]
I feel like I should use an IF formula but I am probably wrong lol.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=MIN(MAX(10,A1),100)
where A1 holds the page count

 

[SRZ712]

Thank you so much!

 

[Scott Huish]

How about:
=MEDIAN(10,A1,100)

 

[Fluff]

Thank you so much!

You're welcome, although Scott's solution is much neater.