Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|