ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide error messages? (https://www.excelbanter.com/excel-discussion-misc-queries/263359-hide-error-messages.html)

Steve A

Hide error messages?
 
I have error messages in a spreadsheet that show because I have not entered
data in another cell. How do I keep this from showing until I enter a value
in another cell that is part of the formula?

Luke M[_4_]

Hide error messages?
 
=IF(Needed_Cell = "","",Formula)

--
Best Regards,

Luke M
"Steve A" wrote in message
...
I have error messages in a spreadsheet that show because I have not entered
data in another cell. How do I keep this from showing until I enter a
value
in another cell that is part of the formula?





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

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