If functions

[kplatt]

Hello everyone. I was wonderin if someone could help me.

I was trying to put in multiple if functions into an excell spreadsheet and the cell would only accept 8 if functions. See below. I needed to put 12 in and the cell would not accept any more than 8. I read that it can take up to 64 nested if functions but for some reason i could only put in 8. Does anyone have any idea why this would be and how i can fix it? Thanks


=IF(I163="gal",H163*L163,IF(I163="% by Volume",H163/100*E163*L163,IF(I163="g/L",H163*3.875/454.5*E163,IF(I163="ml",H163/1000/3.785*L163,IF(I163="ppm",E163/1000000,IF(I163="lb/gal",H163*E163,IF(I163="lb",H163,IF(I163="gal/gal",H163*E163*L163,))))))))

 

[HaHoBe]

Hi, kplatt,

either use VLOOKUP and a table instead of all the Ifs (maybe CHOOSE could work out nicely) or follow 7 Ifs with an AND and the rest of your Ifs...

Ciao,
Holger