calculate cell value with a minimum to be displayed

[Dearoledad]

I need to calculate an "Admin Allocation" of 5% of revenue but the result
cannot be less than $500.00. Example below-
A
1 4500.00
2

Using above cells, A1*0.05 equals 225 in A2 but I since A2 is less than $500
I need to force A2 to be $500.

What is the correct formula for this?

 

[Lars-Åke Aspelin]

I need to calculate an "Admin Allocation" of 5% of revenue but the result
cannot be less than $500.00. Example below-
A
1 4500.00
2

Using above cells, A1*0.05 equals 225 in A2 but I since A2 is less than $500
I need to force A2 to be $500.

What is the correct formula for this?

Try this formula in cell A2:

=MAX(A1*0.05, 500)

Hope this helps / Lars-Åke

 

[Bernd P]

=MAX(500,A1*0.05)

Regards,
Bernd

 

[Ron@Buy]

Try:
=IF(A1*0.05<500,500,A1*0.05)