Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then else
Basically, I am trying to create an if then else statement in Excel and I
have no idea how to do it. What I am trying to achieve is... IF ( K2 between 8 and 14 ) THEN ((K2 -7) * .05) ELSE IF (K2 = 15 ) THEN (((K2 - 14) *.07) + .30) ELSE ( K2 * .0 ) Can anyone help me on this??? Thank you! MAE |