calculate cell value with a minimum to be displayed

  • Thread starter Thread starter Dearoledad
  • Start date Start date
D

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?
 
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?
Click to expand...

Try this formula in cell A2:

=MAX(A1*0.05, 500)

Hope this helps / Lars-Åke
 
Back
Top