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

1-10 pages = 10.00 11+ @ 1.00 per page 100.00 Maximum

<colgroup><col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <tbody> </tbody>

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.