Formula assistance - if / then statement

  • Thread starter Thread starter jmcclain
  • Start date Start date
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
 
Just use a MAX()

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