Too Many IF Statements in Google Sheets [duplicate]

Posted on

Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want. However, every Formula user, irrespective of whether it’s a beginner or expert, has invariably come across a formula parse error in Google Sheets at least once in their life (and if you haven’t. you soon will). It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious. In this article, we will talk about some common formula parse errors in Google Sheets, like Too Many IF Statements in Google Sheets [duplicate], and how to fix it.

I am trying to get this formula to not come back with an error. As far as I know, I cannot make a VLOOKUP chart in Google Sheets because of it looking at multiple cells to give out the value. It worked fine until I wanted it to search for the “BD” value.

=if(B2="New",LOOKUP(T2,{50%,83.5%,91.5%,99.5%},{0.01*F2,0.09*F2,0.12*F2,0.15*F2}), if(B2="Rehash",LOOKUP(T2,{50%,74.5%,76.5%,79.5%,83.5%,85.5%,87.5%,89.5%,94.5%,99.5%},{0.01*I2,0.02*I2,0.03*I2,0.05*I2,0.07*I2,0.08*I2,0.09*I2,0.1*I2,0.11*I2,0.12*E2}), if(B2="Self",LOOKUP(T2,{50%,83.5%,91.5%,99.5%},{0.01*F2,0.12*F2,0.17*F2,0.2*F2}), if(B2="BD",I2*0.09), if(B2="BD1",I2*0.05), if(B2="BD2",I2*0.01), if(B2="Family",I2*0))))

Answer :

I wound up expanding the gaps of the LOOKUP of the first 3 eliminating the need for the rest. It simplified the formula.

Leave a Reply

Your email address will not be published.