Formula issue

[Szucchari]

Hi guys, I give up! I cant figure this out please help!

I need a formula to come up with the money for this:

1-100 pages @ $1 per page, 101+ pages @ $0.25 per page up to a maximum of $200 flat rate.

I need this all to configure by just putting in the total page numbers into a cell.

Thank you!

 

[Joe4]

Welcome to the Board!

Try this for page numbers in cell A1:

=MIN(MIN(A1,100)+MAX(0,A1-100)*0.25,200)

 

[Szucchari]

Thank you!!!!!!!!!!!!!!

 

[Joe4]

You are welcome.

I hope it makes sense. If you break it apart bit-by-bit, hopefully the logic becomes apparent.
If not and you have any questions, just let me know.