How do I put more than 7 IF formula in a single cell?
There is a maximum set up for how many IF functions can be directly in a row
in a cell. My example:
=IF(AND(B450,B45<1000,1,IF(AND(B451000,B45<3000, 2,IF.... I would like to
continue this out to about 40, is this possible? or can I use some other
formula to make this work correctly?
|