Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
If cell C18 has a value return me that value if it is blank return me cell 21 but if cell c21 doesn't have a value return me cell e21, if that is also blank return me I21.
Here are the 3 formulas I have been trying and they all only work in certain instances.
=IF(ISBLANK(C18),IF(ISBLANK(C21),IF(ISBLANK(E21),I21,E21),C21),C18)
=IFERROR(1/(1/C18),IF(ISBLANK(C18),C21,IF(ISBLANK(E21),I21,E21)))
=IF(C18=" ",C21,IF(C21=" ",E21,IF(E21=" ",I21,IF(I21=" ","Not Selected",C18)*C21)*E21)*I21)
Here are the 3 formulas I have been trying and they all only work in certain instances.
=IF(ISBLANK(C18),IF(ISBLANK(C21),IF(ISBLANK(E21),I21,E21),C21),C18)
=IFERROR(1/(1/C18),IF(ISBLANK(C18),C21,IF(ISBLANK(E21),I21,E21)))
=IF(C18=" ",C21,IF(C21=" ",E21,IF(E21=" ",I21,IF(I21=" ","Not Selected",C18)*C21)*E21)*I21)