Forum Discussion
IF statement based on multiple columns.
Vendor 1 Vendor 2 Vendor 3 Vendor Master ABC BCD CDE Hi everyone, I'm trying to put up a IF formula for the following scenario. But I'm facing diffic...
I'm pretty sure someone will have a more eloquent formula but this can be done with nested IF formula - see attached example
=IF($A2>"",$A2,IF($B2>"",$B2,IF($C2>"",$C2,0)))