| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need assistance with a formula - If then??? | Excel Worksheet Functions | |||
| Need assistance with a formula - If then statement? | Excel Discussion (Misc queries) | |||
| Assistance with formula in SumIf statement | New Users to Excel | |||
| Formula Assistance | Excel Discussion (Misc queries) | |||
| I need assistance setting up a "IF" statement | Excel Worksheet Functions | |||
Linear Mode
