Forum Discussion
Solved
Using IFBLANK with IF Formulas
Using Excel for Mac 16.52 and have an (IF this value, this formula, default formula) set up but am trying to use IFBLANK up front so it only generates a result when it's supposed to (when the cell be...
Yes:
=IF(F1="", "", IF(F1="Standard", ..., IF(F1="Full", ...)))
or
=IFS(F1="", "", F1="Standard", ..., F1="Full", ...)
Yes:
=IF(F1="", "", IF(F1="Standard", ..., IF(F1="Full", ...)))
or
=IFS(F1="", "", F1="Standard", ..., F1="Full", ...)
Thanks, Hans! I'm stepping out but will try this next and respond here. Thank you!