|
|
|
|
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
|