calculate cell value with a minimum to be displayed
 

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?

calculate cell value with a minimum to be displayed
 

On Fri, 16 Oct 2009 16:34:01 -0700, Dearoledad
wrote:

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

calculate cell value with a minimum to be displayed
 

=MAX(500,A1*0.05)

Regards,
Bernd

calculate cell value with a minimum to be displayed
 

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


"Dearoledad" wrote:

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?