Forum Discussion
IF Function Referencing Multiple & Return Blank
Hi, So I'm starting my exploration into Excel and formulas so my question is basic but so far I haven't cracked it so I'm asking for a little guidance on Nested IF 🙂 In one cell I have the p...
Hello,
Your formula is accurate without any error. However, the issue of blank cell is what I didnt catch well. If you want your output cell to be blank, all you need to do is use double quote. That's the way to tell Excel to return empty blank cell if the condition is False in your example.
See this below
Assume you have 50 in cell A1
=IF(A1<40,70,"")
The above formula evaluate if the value in cell A1 is less 40, if it is true, it will return 40. But in this case, it is false. So it will return an empty blank cell...
Your formula is accurate without any error. However, the issue of blank cell is what I didnt catch well. If you want your output cell to be blank, all you need to do is use double quote. That's the way to tell Excel to return empty blank cell if the condition is False in your example.
See this below
Assume you have 50 in cell A1
=IF(A1<40,70,"")
The above formula evaluate if the value in cell A1 is less 40, if it is true, it will return 40. But in this case, it is false. So it will return an empty blank cell...