Excel help

[rdowns]

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?

 

[bearbo]

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"

 

[savar]

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

where A1 is your "a number"

if(a1>250,(if(a1<1000,a1*.08,80),20)

 

[emw]

=max(min(0.08*a1,80),20)

 

[rdowns]

Thanks. Worked like a charm.

 

[emw]

What - you're not going to tell us which one you used? 😛