Hi All,
I am using Excel 2013.
Trying to Nest 10 IF Statements but getting a syntax error.
The following are what I am try to Nest only using 3 as example:
IF(B7="No Adhesive",(B6+Sheet1!B9),"ERROR")
IF(B7="1 x 6/9mm SP",(B6+Sheet1!B10),"ERROR")
IF(B7="2 x 6/9mm SP",(B6+Sheet1!B11),"ERROR")
When I combine them:
IF(B7="No Adhesive",(B6+Sheet1!B9),"ERROR"),IF(B7="1 x 6/9mm SP",(B6+Sheet1!B10),"ERROR"),IF(B7="2 x 6/9mm SP",(B6+Sheet1!B11),"ERROR")
Not Working...tried various additions of parentheses no joy.
Grateful for any help.
At the moment dabbling in vlookup but results are iffy.
Thanks
I am using Excel 2013.
Trying to Nest 10 IF Statements but getting a syntax error.
The following are what I am try to Nest only using 3 as example:
IF(B7="No Adhesive",(B6+Sheet1!B9),"ERROR")
IF(B7="1 x 6/9mm SP",(B6+Sheet1!B10),"ERROR")
IF(B7="2 x 6/9mm SP",(B6+Sheet1!B11),"ERROR")
When I combine them:
IF(B7="No Adhesive",(B6+Sheet1!B9),"ERROR"),IF(B7="1 x 6/9mm SP",(B6+Sheet1!B10),"ERROR"),IF(B7="2 x 6/9mm SP",(B6+Sheet1!B11),"ERROR")
Not Working...tried various additions of parentheses no joy.
Grateful for any help.
At the moment dabbling in vlookup but results are iffy.
Thanks