IF + AND string - Help!
 

if(and(i4<1500,i41400),1.039, if(and(i4<1400,i41300), 1.082,
if(i4<1300,i41200),1.132,
if(and(i4<1200,i41100),1.185,if(and(i4<1100,i410 00),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

You missed AND in the second line:

if(AND(i4<1300,i41200),1.132,

Stefi

€žBigDave€� ezt Ã*rta:


if(and(i4<1500,i41400),1.039, if(and(i4<1400,i41300), 1.082,
if(i4<1300,i41200),1.132,
if(and(i4<1200,i41100),1.185,if(and(i4<1100,i410 00),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

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

Peace,
--Carl

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

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