ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Return an empty or blank cell value? (https://www.excelbanter.com/excel-worksheet-functions/75153-return-empty-blank-cell-value.html)

Troymello

Return an empty or blank cell value?
 
When I use the IF function in most cases, I want it to either show some text
or nothing at all. I have always performed this function as in the following
example:

=IF(A1=5,"Five"," ")

If A1 is not equal to five, then my cell will show a space which makes it
appear to look empty or blank... a cheap fix I suppose. Is there a way to
make a cell truly act as if it were completely empty in this case?... without
cheating with a " " space or without returning a zero (0)? Thanks much for
any info.


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com