| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement in formula
is it possible to do this:
D2 = A2 * if(B1= "1/4 points", A2/4, if(B2="1/8 points", A2/8)) * A3 a b c d 1 LENGTH POSITION HEIGHT ANSWER 2 12 "1/4 points" 24 864 3 12 "1/8 points" 24 432 with my if statement... to avoid writing my formula 3 times... this is a hugely simplified formula - the actual one is several lines long, and i'd like to minimize code. thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with if-then statement in formula | Excel Discussion (Misc queries) | |||
| IF statement formula | Excel Worksheet Functions | |||
| Can I use IF statement with a formula? | Excel Worksheet Functions | |||
| if statement formula | Excel Discussion (Misc queries) | |||
| If statement formula | Excel Worksheet Functions | |||
Threaded Mode
