I need another way to do this:
=IF(E5=0,D4,IF(H5=0,G4,IF(K5=0,J4,IF(N5=0,M4,""))))
This formula works for me, but I can't make it long enough. It only allows me to use 7 IF funtions. I have more than that to put it, and it has to look them up in order.
=IF(E5=0,D4,IF(H5=0,G4,IF(K5=0,J4,IF(N5=0,M4,""))))
This formula works for me, but I can't make it long enough. It only allows me to use 7 IF funtions. I have more than that to put it, and it has to look them up in order.