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