Nested if statements containing multiple and statements

**John M.** · 06-22-2014, 04:19 PM

I am having a hard time getting a nested if statement containing multiple and statements as listed below;

a1=7
a2=9

What i am looking for is;
If a1 is less than 15 and a2 is reater than 3 then give answer of 1
if a1 is less than 15 and a2 is greater than 5 then give answer of 2

Here is what i tried with no luck..

If(AND(a1<15,a2>3),1, if(and(a1,15,a2>5),2))

Can anybody help me with this?

**John M.** · 06-22-2014, 04:22 PM

made a slight mistake in previous post...here is the corrected version of what i have tried with no luch...

If(AND(a1<15,a2>3),1, if(and(a1<15,a2>5),2))

**FDibbins** · 06-22-2014, 04:43 PM

Hi and welcome to the forum

What i am looking for is;
If a1 is less than 15 and a2 is reater than 3 then give answer of 1
if a1 is less than 15 and a2 is greater than 5 then give answer of 2

=if(A1<15,if(A2>5,2,1),"")

You did not say what to do is A1 >15, so I used ""

edit: Not that I would advocate doing it this way, but to correct how you were trying to do it...
If(AND(a1<15,a2>5),2, if(and(a1<15,a2>3),1),"")

**John M.** · 06-22-2014, 09:08 PM

This says there are too many arguments... still not working.

**John M.** · 06-22-2014, 09:09 PM

i will copy the actual spreadsheet later this eve... Thanks for the help.

**benishiryo** · 06-22-2014, 09:28 PM

welcome to the forum, John M. you can use the 1st formula provided by FDibbins. that should work for you. the 2nd formula he advised on correcting your formula should be:
=IF(AND(A1<15,A2>5),2,IF(AND(A1<15,A2>3),1,""))