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])
This is perfect! Many thanks, Ashish! 🙂
You are welcome.