Excel =If(ISBLANK) with 4 columns
Posted on 2013-11-12
I have an existing formula in C that puts the number in Cell A into Cell C if B is blank. otherwise it puts B into C
What I need is a formula in Column D that puts A into D if B and C are blank, or puts B into D if C is blank, otherwise, it puts C into D.
In other words here is what should be in D for each row:
A B C D
5 6 6
2 3 1 1
It was easy with only 3 columns using =IF(ISBLANK(B121),A121,B121) but I haven't found an example using 4 columns.
Thanks in advance,