Writing a nested-if formula in excel

May 9, 2012 at 01:32:26
Specs: Windows 7
I have tried to write a formula for the following but could not succeed:
If A1>=160000 but <360000 and B1=”January-December” outcome should be “125”
And if A1<160000 result should be “0”
And if A1>=360000 and B1=”March” the outcome should be “300”
And if A1>=360000 and B1=”April-February” the outcome should be “200”
I had tried to nest the following two formulae but couldn’t.
=IF(AND(A1>=160000,A1<360000,B1=”JANUARY-DECEMBER”),”125”,”0”
=IF(AND(A1>=360000,B1=”MARCH”),”300”,”200”
Please help me in writing a nested-IF formula for this.

See More: Writing a nested-if formula in excel

Report •


#1
May 9, 2012 at 06:17:42
B1=”JANUARY-DECEMBER”

Unless cell B1 contains the Literal String of Text Characters: JANUARY-DECEMBER
your formula will fail.

What is the data in column B?

As a quick work around, since you are looking for the entire Year, just
check to make sure B1 is Not Blank:

B1 <> ""

See if that helps.

MIKE

http://www.skeptic.com/


Report •

#2
May 9, 2012 at 09:04:45
Data in cell B1 will be any month from January to December

Report •

#3
May 9, 2012 at 09:28:20
Did you try my suggestion of testing if not blank like:

=IF(AND(A1>=160000,A1<360000,B1<>””),”125”,”0”

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question