IF + AND string - Help!

[BigDave]

if(and(i4<1500,i4>1400),1.039, if(and(i4<1400,i4>1300), 1.082, if(i4<1300,i4>1200),1.132, if(and(i4<1200,i4>1100),1.185,if(and(i4<1100,i4>1000),1.262,1))))

I'm getting an error indicator at 1.132. I thought I could nest 7 IF statements together? What am I missing?

[Stefi]

You missed AND in the second line:

> > if(AND(i4<1300,i4>1200),1.132,

Stefi

„BigDave” ezt �*rta:

>
> > if(and(i4<1500,i4>1400),1.039, if(and(i4<1400,i4>1300), 1.082,
> > if(i4<1300,i4>1200),1.132,
> > if(and(i4<1200,i4>1100),1.185,if(and(i4<1100,i4>1000),1.262,1))))
>
> I'm getting an error indicator at *1.132*. I thought I could nest 7 IF
> statements together? What am I missing?
>
>
> --
> BigDave
> ------------------------------------------------------------------------
> BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741
> View this thread: http://www.excelforum.com/showthread...hreadid=471726
>
>

[BigDave]

BigDave = idiot

Thanks

[Stefi]

Don't be so rude to yourself! It can happen to anybody. Somtimes a fresh eye
catches sight more easily.
Stefi


"BigDave" wrote:

>
> BigDave = idiot
>
> Thanks
>
>
> --
> BigDave
> ------------------------------------------------------------------------
> BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741
> View this thread: http://www.excelforum.com/showthread...hreadid=471726
>
>

[carl.manaster@gmail.com]

You're missing an "and" - the 1300, 1200 comparision needs to be
wrapped with and().

Peace,
--Carl