Formula assistance - if / then statement
 

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

Formula assistance - if / then statement
 

Just use a MAX()

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

"jmcclain" wrote:

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