Nested if error

Euro5
Euro5 used Ask the Experts™
on
I have tried to modify this formula, but now getting error - I know I'm using wrong number of parenthesis or something simple, but can't figure it out!
Can anyone help??

=IF(OR(K2="SPOZ",K2="SPOZDEF"),AB2,ROUNDUP(IF(AND(OR($K2={"SPLB","SPLBDEF","SPLBHW","SPLBDEFHW"}),'Enter Data'!$B$4=""),$G2/'Enter Data'!$A$4,IF(AND(OR($K2={"SPLB","SPLBDEF","SPLBHW","SPLBDEFHW"}),$G2>=('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$C$4,IF(AND(OR($K2={"SPLB","SPLBDEF","SPLBHW","SPLBDEFHW"}), $G2/'Enter Data'!$A$4, IF(AND(OR($A2={"E2","ESP","FO","PO","SO","E2AM","F1","F2","F3"}),'Enter Data'!$B$2=""),$G2/'Enter Data'!$A$2, IF(AND(OR($A2={"E2","ESP","FO","PO","SO","E2AM","F1","F2","F3"}),$G2>=('Enter Data'!$B$2*1728)),$G2/'Enter Data'!$A$2, IF(AND(OR($A2={"E2","ESP","FO","PO","SO","E2AM","F1","F2","F3"}),$G2<('Enter Data'!$B$2*1728)),$G2/'Enter Data'!$C$2, IF(AND($A2="HD",'Enter Data'!$B$7=""),$G2/'Enter Data'!$A$7,IF(AND($A2="HD",$G2>=('Enter Data'!$B$7*1728)),$G2/'Enter Data'!$A$7, IF(AND($A2="HD",$G2<('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$C$7, IF(AND(OR($A2={"GR","PRP"}),'Enter Data'!$B$4=""),$G2/'Enter Data'!$A$4, IF(AND(OR($A2={"GR","PRP"}),$G2>=('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$A$4,IF(AND(OR($A2={"GR","PRP"}), $G2<('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$C$4,IF($E2="PR",$G2/'Enter Data'!$A$2,IF(AND(OR($A2={"IP","IE","IPF","IEF"}), 'Enter Data'!$B$10="",D2="Exp"),$G2/'Enter Data'!$A$10,IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2>=('Enter Data'!$B$10*1728),D2="Exp"), $G2/'Enter Data'!$A$10,IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2<('Enter Data'!$B$10*1728),D2="Exp"), $G2/'Enter Data'!$C$10,IF(AND(OR($A2={"IP","IE","IPF","IEF"}),'Enter Data'!$B$13="",D2="Imp"),$G2/'Enter Data'!$A$13, IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2>=('Enter Data'!$B$13*1728),D2="Imp"),$G2/'Enter Data'!$A$13, IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2<('Enter Data'!$B$13*1728),D2="Imp"),$G2/'Enter Data'!$C$13,0)))))))))))))))))))),0))

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Does this work?
=IF(OR(K2="SPOZ",K2="SPOZDEF"),AB2,ROUNDUP(IF(AND(OR($K2={"SPLB","SPLBDEF","SPLBHW","SPLBDEFHW"}),'Enter Data'!$B$4=""),$G2/'Enter Data'!$A$4,IF(AND(OR($K2={"SPLB","SPLBDEF","SPLBHW","SPLBDEFHW"}),$G2>=('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$C$4,IF(AND(OR($K2={"SPLB","SPLBDEF","SPLBHW","SPLBDEFHW"})), $G2/'Enter Data'!$A$4, IF(AND(OR($A2={"E2","ESP","FO","PO","SO","E2AM","F1","F2","F3"}),'Enter Data'!$B$2=""),$G2/'Enter Data'!$A$2, IF(AND(OR($A2={"E2","ESP","FO","PO","SO","E2AM","F1","F2","F3"}),$G2>=('Enter Data'!$B$2*1728)),$G2/'Enter Data'!$A$2, IF(AND(OR($A2={"E2","ESP","FO","PO","SO","E2AM","F1","F2","F3"}),$G2<('Enter Data'!$B$2*1728)),$G2/'Enter Data'!$C$2, IF(AND($A2="HD",'Enter Data'!$B$7=""),$G2/'Enter Data'!$A$7,IF(AND($A2="HD",$G2>=('Enter Data'!$B$7*1728)),$G2/'Enter Data'!$A$7, IF(AND($A2="HD",$G2<('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$C$7, IF(AND(OR($A2={"GR","PRP"}),'Enter Data'!$B$4=""),$G2/'Enter Data'!$A$4, IF(AND(OR($A2={"GR","PRP"}),$G2>=('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$A$4,IF(AND(OR($A2={"GR","PRP"}), $G2<('Enter Data'!$B$4*1728)),$G2/'Enter Data'!$C$4,IF($E2="PR",$G2/'Enter Data'!$A$2,IF(AND(OR($A2={"IP","IE","IPF","IEF"}), 'Enter Data'!$B$10="",D2="Exp"),$G2/'Enter Data'!$A$10,IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2>=('Enter Data'!$B$10*1728),D2="Exp"), $G2/'Enter Data'!$A$10,IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2<('Enter Data'!$B$10*1728),D2="Exp"), $G2/'Enter Data'!$C$10,IF(AND(OR($A2={"IP","IE","IPF","IEF"}),'Enter Data'!$B$13="",D2="Imp"),$G2/'Enter Data'!$A$13, IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2>=('Enter Data'!$B$13*1728),D2="Imp"),$G2/'Enter Data'!$A$13, IF(AND(OR($A2={"IP","IE","IPF","IEF"}),$G2<('Enter Data'!$B$13*1728),D2="Imp"),$G2/'Enter Data'!$C$13,0))))))))))))))))))),0))

Open in new window

Author

Commented:
THANK YOU!!!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You'r welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial