Formula assistance - if / then statement

J

jmcclain

I have 3 columns.

I = cost
J = min price
K = current price

I need to calculate the gross mark based on either the min price (j) or the
current price (K), whichever if greater. I have the formula to calculate the
gross, but the syntax for the if-then is eluding me.

Any asisstance is greatly appreciated.

Jon
 
S

Sean Timmons

Just use a MAX()

=MAX(J2,K2) will return the greater value. Bake that into your statement.
 
Top