View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derrick Derrick is offline
external usenet poster
 
Posts: 133
Default 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,