IF Formula
 

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,

IF Formula
 

=IF(B2=2006,15,IF(B2=2007,30,IF(B2=2008,45,"no match")))

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,

IF Formula
 

On Oct 10, 6:34 pm, 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,

If you only have a few years to check you could indeed use the if-
function, like this:
=IF(B2=2006;15;IF(B2=2007;30;IF(B2=2008;45;"")))

If you have many years, or as time goes by, I would consider a table
and the vlookup-function.

Per Erik

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,

IF Formula
 

Try this:

=(B2-2005)*15


"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,