Good evening,
I'm trying a nested if function but getting the error message that I have too many arguments. The formula is as follows
=IFERROR(IF(AND(H2>=1, H2<=7), B2*150, C2*110, D2*90, E2*75,F2*60, G2*60, IF(H2=8, B2*170, C2*125, D2*100, E2*85,F2*65,G2*60, IF(H2=9, B2*180, C2*135, D2*110,E2*90, F2*70,G2*60, IF(H2=10, B2*190, C2*145, D2*115, E2*95,F2*75,G2*60, IF(AND(H2>=11,H2<=20), B2*210, C2*160, D2*125, E2*105,F2*85,G2*60, IF(AND(H2>=21, H2<=22), B2*230, C2*175, D2*140, E2*115,F2*90,G2*60, IF(AND(H2>=23, H2<=24),B2*255, C2*190, D2*155, E2*125,F2*100,G2*60, IF(AND(H2>=25, H2<=26), B2*275, C2*205, D2*165, E2*135,F2*110, G2*60, IF(AND(H2>=27, H2<=28), B2*300, C2*225, D2*180, E2*150,F2*120,G2*60, IF(AND(H2>=29, H2<=30), B2*320, C2*240, D2*190, E2*160,F2*130, G2*60, IF(AND(H2>=31, H2<=32), B2*345, C2*260, D2*205, E2*170,F2*140, G2*60, IF(AND(H2>=33, H2<=34), B2*370, C2*275, D2*220, E2*185,F2*150, G2*60, IF(AND(H2>=35, H2<=36), B2*390, C2*290, D2*235, E2*195,F2*155, G2*60, IF(AND(H2>=37, H2<=38), B2*460, C2*345, D2*275, E2*230,F2*185, G2*60, IF(AND(H2>=39, H2<=50), B2*485, C2*365, D2*290, E2*240,F2*195, G2*60),0)
What are my alternatives to this if function. I'm assuming a Macro VBA is my best bet. Any assistance would be great appreciated
Bookmarks