This works for me

= A2*IF(B2="1/4 points",A2/4,IF(B2="1/8 points",A2/8))*A2

although it is half the number that you show


--
__________________________________
HTH

Bob

"Derrick" wrote in message
...
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,