How can I use Excel Formulas to return multiple values using nested IF statements if I need one of the returnable values to be blank?
Solution 1:
When you are using a formula IF(H1=FALSE,[VALUE IF TRUE],[VALUE IF FALSE])
the formula checks for a FALSE
or a blank cell in H1
.
If you wish to retain your current requirements, put the if blank at the beginning.
=IF(IF(H1="","",IF(H1=TRUE,"Tested",IF(H1=FALSE,"Not Tested","ERROR")))
The "ERROR" bit will highlight an error in cell H1