M
Monomeeth
Okay, not sure why this isn't working so need your help.
In cell AA2 I have the following formula: =TODAY()
In cell AB2 I have the following formula: =MONTH(AA2)
Cell AA2 returns today's date. Cell AB2 returns the month of the date in
AA2. So far so good.
Now here's the problem:
In Cell C3 I have the following formula: =IF(AB2="5",AB6,"")
But for some reason this returns a blank result. Because we're in May, cell
AB2 does = 5, so that tells me that in cell C3 I should get the result of
whatever is in cell AB6. Cell AB6 has $35,500.00 in it, and this is what I
was expecting to get in cell C3.
I want to get this sorted out as I intend to have a nested IF statement to
allow for twelve possibilities ranging from 1 to 12.
Any suggestions of how to fix this? Or is there a better way to achieve the
same thing?
And, will I run into problems if I have twelve IF statements in my formula,
or will Excel handle that ok?
I'm using Excel 2003 SP2.
Thanks.
Joe.
In cell AA2 I have the following formula: =TODAY()
In cell AB2 I have the following formula: =MONTH(AA2)
Cell AA2 returns today's date. Cell AB2 returns the month of the date in
AA2. So far so good.
Now here's the problem:
In Cell C3 I have the following formula: =IF(AB2="5",AB6,"")
But for some reason this returns a blank result. Because we're in May, cell
AB2 does = 5, so that tells me that in cell C3 I should get the result of
whatever is in cell AB6. Cell AB6 has $35,500.00 in it, and this is what I
was expecting to get in cell C3.
I want to get this sorted out as I intend to have a nested IF statement to
allow for twelve possibilities ranging from 1 to 12.
Any suggestions of how to fix this? Or is there a better way to achieve the
same thing?
And, will I run into problems if I have twelve IF statements in my formula,
or will Excel handle that ok?
I'm using Excel 2003 SP2.
Thanks.
Joe.