Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hide the returned value "false" I have submerged zero values
Although I have submerged zero values, and hidden formulas, the cell still
displays "false" when the if statement has not been met. How can I have the word "false" submerged. |
#2
|
|||
|
|||
Hi!
Use a return of zero in your IF function when the logical test is FALSE. An alternative, use conditional formatting to hide them. Conditional Formatting: Cell value is: equal to: FALSE Set the font color to be the same as the background color Biff "Ms Trish" <Ms wrote in message ... Although I have submerged zero values, and hidden formulas, the cell still displays "false" when the if statement has not been met. How can I have the word "false" submerged. |
#3
|
|||
|
|||
=IF(A1=X,200,"")
meaning if the condition is not met return blank adapt to fit -- Regards, Peo Sjoblom (No private emails please) "Ms Trish" <Ms wrote in message ... Although I have submerged zero values, and hidden formulas, the cell still displays "false" when the if statement has not been met. How can I have the word "false" submerged. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
link data to new workbook | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |