Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

rdowns

macrumors Penryn
Original poster
Jul 11, 2003
27,397
12,521
I need to write a formula to calcualte a fee.

The fee is 8% of a number.
The minimum fee is $20
The maximum fee is $80

How would I do that?
 
I need to write a formula to calcualte a fee.

The fee is 8% of a number.
The minimum fee is $20
The maximum fee is $80

How would I do that?

=IF(A1*0.08>20,IF(A1*0.08<80,A1*0.08,80),20)

where A1 is your "a number"
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.