Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet where in some cells I want the cell to show
nothing if a condition is not met: For example, in cell A1: = IF (a = b, a + b, "") If in A2 when a<b, I check to see if this value is greater than 0, it returns TRUE: = A1 0 I can even simplify A1 just to be: = "" and the it still returns that this cell 0. Can someone please explain and maybe offer an alternative way to display nothing in a cell that will register as a 0? Thanks. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple formatting in text cell blank it out! | Excel Discussion (Misc queries) | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Capitalize Text if 2 lists are equal | New Users to Excel | |||
How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |