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. |
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. |
=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. |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com