IF Formula
hi
=if(B2=2006,15,if(B2=2007,30,if(B2=2008,45,0)))
you can nest up to 7 ifs within an if statement. you can have more but that
reguires using more that 1 if statement and that can get tricky.
Regards
FSt1
"bmo" wrote:
I have an if formula "=IF(B2=2006,15)" which works fine, but I would like to
expand it to also include "=IF(B2=2007,30)", but I can't figure out how to
write it. I would even like "=IF(B2=2008,45)" if its possible.
Thanks,
|