Forum Discussion
Help with IF multiple if statements
I have 4 columns with different values. I need a function that: IF Column Value1 is empty, take Column Value2, and if this one is empty, take Column Value3, and if that one is empty, take Column ...
Hi,
Try this calculated column formula
=if(isblank(Data[Column1]),if(isblank(Data[Column2]),if(isblank(Data[Column3]),Data[Column4],Data[Column3]),Data[Column2]),Data[Column1])
Thank you. It worked, You're a saviour 🙂
You are welcome. Please mark my previous reply as Answer.