Nested IF formula

  • Thread starter Thread starter Tony Rielly
  • Start date Start date
T

Tony Rielly

I am trying to write a nested IF formula that has more than seven functions.
On the Excel help it states only seven IF functions can be nested. Is there
any other way to create a formula that will give me the answer I am looking
for?

MONTH 6

A1 Jan 1000
B1 Feb 2000
C1 March 1000
D1 April 3000
E1 May 1000
F1 June 1000
G1 July 1000
H1 Aug 2000
I1 Sept 3000
J1 Oct 1000
K1 Nov 1000
L1 Dec 1000
18000

The result I am looking for is if Jan is month 1, Feb month 2 etc. and I am
looking for the total for Month 6

And the formuls is as follows :
=IF(MONTH=1,A1,IF(MONTH=2,B1,IF(MONTH=3,C1,IF(MOTNTH=4,D1,IF(MONTH=5,E1,IF(M
ONTH=6,F1,IF(MONTH=7,G1,IF(MONTH=8,H1,IF(MONTH=9,I1,IF(MONTH=10,J1,IF(MONTH=
11,K1,IF(MONTH=12,L1))))))))))))

So as above because MONTH=6 the result of the formula should be 1000
If the month were 9 then the result should be 3000

Hopefully someone can help

Thank you.
 
Tony,

A HLOOKUP would work here. (It appears that your data is in rows)

=HLOOKUP("month",A1:L2,2,FALSE)

Though, you would have to use Jan,Feb,Mar.... as your reference rather than
1,2,3.... as that is what is in your table.

HTH

PC
 
Back
Top