Jacob-
thanks, and that would work, but the goal was to know if having an if
statment would work - the formula below was a simplified example of one im
working on. so, albeit shorter, quite unneccessary lol.

Thanks

"Jacob Skaria" wrote:

TRY

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

If this post helps click Yes
---------------
Jacob Skaria


"Derrick" wrote:

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,