Why doesn't this nested IF statement work?

B

Brandoni

I have six columns next to each other and am trying to add date based on the
month in every other column.

M8 N8 O8 P8 Q8 R8
$200 April $100 May $100 April

Then trying to have the formula add any combination of M8,08 and Q8 that
have "April" next to them. So the formula checks to see if it should add all
three, or two, or just one. In this example, the returned result should be
$300.

I keep getting an error. Any help?

=IF(N8="April",IF(P8="April",IF(R8="April",(M8+O8+Q8),if(N8="April",IF(P8="April",(M8+O8),(IF(N8="April",IF(R8="April",((M8+Q8),IF(N8="April",M8,IF(P8="April",o8,IF(R8="April",Q8,0),0),0),0),0),0),0),0),0),0),0),0)
 
M

Miguel Zapico

You may use a simpler formula like:
=if(N8="April",M8,0)+if(P8="April",O8,0)+if(R8="April",Q8,0)
 
K

Kevin Vaughn

Try this one:

=M8*(N8="April")+O8*(P8="April")+Q8*(R8="April")
The answer to your question is you probably have too many nested Ifs (only 7
are allowed.) A quick glance at it indicates you do.
 
D

Don Guillett

for this simple example, a simple solution
=IF(B2="April",A2)+IF(D2="April",D2)+IF(F2="April",E2)
 
B

Bob Phillips

=SUMPRODUCT(SUMIF(INDIRECT({"N8","P8","R8"}),"April",INDIRECT({"M8","O8","Q8
"})))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Brandoni said:
I have six columns next to each other and am trying to add date based on the
month in every other column.

M8 N8 O8 P8 Q8 R8
$200 April $100 May $100 April

Then trying to have the formula add any combination of M8,08 and Q8 that
have "April" next to them. So the formula checks to see if it should add all
three, or two, or just one. In this example, the returned result should be
$300.

I keep getting an error. Any help?
=IF(N8="April",IF(P8="April",IF(R8="April",(M8+O8+Q8),if(N8="April",IF(P8="A
pril",(M8+O8),(IF(N8="April",IF(R8="April",((M8+Q8),IF(N8="April",M8,IF(P8="
April",o8,IF(R8="April",Q8,0),0),0),0),0),0),0),0),0),0),0),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top