Forum Discussion
Hayley Birt
Sep 20, 2017Copper Contributor
IF function with ISBlank
Hello, Scenario: If A1 is blank, try to get data from B1. If B1 is blank as well, try to get data from C1 If A1 is not blank, continue to use the data from A1. I have =IF(ISBLANK(A1),B...
SergeiBaklan
Sep 20, 2017Diamond Contributor
I'd suggest
=IF(ISBLANK(A1)*ISBLANK(B1),C1,IF(ISBLANK(B1),A1,B1))
- start from the end