Formula error on nested if statement

**tstackhouse10** · 07-20-2017, 08:27 AM

I have created the formula below and I am getting a "too many arguments error." I have created this type of formula before and it has worked, it is a fairly simple nested IF statement. It is basically saying if the number in cell I15 is between the values in cells S11 and U11 then return W11 and if not go to the next row down. I have gone down though this and I cannot seem to find any comma or parenthesis errors. Any insight on what would cause this would help!
Thanks!

=if(I15<S11,"N/A",if(and(I15>S11,I15<U11),W11,if(and(I15>S12,I15<U12),W12,if(and(I15>S13,I15<U13),W13,if(and(I15>S14,I15<U14),W14),if(and(I15>S15,I15<U15),W15,if(and(I15>S16,I15<U16),W16,if(and(I15>S17,I15<U17),W17,if(and(I15>S18,I15<U18),W18,if(and(I15>S19,I15<U19),W19,if(and(I15>S20,I15<U20),W20,if(and(I15>S21,I15<U21),W21,if(and(I15>S22,I15<U22),W22,if(and(I15>S23,I15<U23),W23,if(and(I15>S24,I15<U24),W24,if(and(I15>S25,I15<U25),W25,if(and(I15>S26,I15<U26),W26,if(and(I15>S27,I15<U27),W27,if(and(I15>S28,I15<U28),W28,if(I15>S29,W29,"??")))))))))))))))))))

**Xandler** · 07-20-2017, 08:46 AM

Okay....so, I noticed that you have a random closing parenthesis at the end of W14, move that to the end and it works, or at least the error message goes away.

**tstackhouse10** · 07-20-2017, 08:48 AM

That was it, I do not know how I missed that!
Thank you Xandler!

**tim201110** · 07-20-2017, 08:50 AM

=lookup(i15,s10:s29/(i15<u10:u29),w10:w29)

**tstackhouse10** · 07-20-2017, 09:00 AM

That formula works as well. Thanks Tim, I will have too keep that for further use!

**Xandler** · 07-20-2017, 11:38 AM

You're welcome, if that takes care of your original problem please mark the thread solved through the thread tools. Don't forget to click the add reputation button for anyone that has helped you!