I have a cell with 7 nested if's in it. I want the cell to be blank is the cell previous to it is blank.
This is my formula (without spaces):
= IF (R40 < $D$20-2,$B$19, IF (R40 < $D$21-2,$B$20, IF (R40 < $D$22-2,$B$21, IF (R40 < $D$23-2,$B$22, IF (R40 < $D$24-2,$B$23, IF (R40 < $D$25-2,$B$24, IF (R40 < $D$2-2,$B$25, IF (R40 < $D$3-2,$B$2))))))))
I know how to do it with one IF formula, using "" at the end, but doesn't seem to work with this forumla?!?
This is my formula (without spaces):
= IF (R40 < $D$20-2,$B$19, IF (R40 < $D$21-2,$B$20, IF (R40 < $D$22-2,$B$21, IF (R40 < $D$23-2,$B$22, IF (R40 < $D$24-2,$B$23, IF (R40 < $D$25-2,$B$24, IF (R40 < $D$2-2,$B$25, IF (R40 < $D$3-2,$B$2))))))))
I know how to do it with one IF formula, using "" at the end, but doesn't seem to work with this forumla?!?