Solved two formula in excel

July 19, 2015 at 05:58:21
Specs: Windows 7
=IF(C5="","OFF") this formula work fine it self but when I put time in cell it's show False , I want show blank or null in that particular cell, where I am using


You can see when i put time 7:30 it's show FALSE, Second one out i empty it's show OFF

My question i want FALSE take out and showing empty cell.

thanks in advance.

See More: two formula in excel

Report •

July 19, 2015 at 07:39:53
✔ Best Answer
I am not sure that I understand your question, but I think I know what you are trying to do. The IF statement works like this": IF(logical test, value if true, value if false). presently, your formula has a logical test : IF C5 = "". your value if true is "OFF". BUT you have nothing for value if false which is why the cell defaults to FALSE. If you want a blank cell then put 2 quotation marks like this "".

so try IF(C5="", "OFF","")

Don C

message edited by dcutl002

Report •

July 19, 2015 at 19:22:38
That's it, it's work perfact., Thanks....

Report •
Related Solutions

Ask Question