I’m trying to display the following but I’m having trouble writing the formula and would be grateful if anyone our there could help.
If B2 & C2 are not blank, display C2, otherwise display B2.
=IF(ISBLANK(B2)=””,””,(C2))
otherwise display B2
=IF(ISBLANK(c2)=””,””,(b2)), if(ISBLANK(B2)=””,””,(C2))