Mark,
If you must hide it, against fixing the problem, then try
=IF(ISERROR((P194*H194)+H194),"",(P194*H194)+H194)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Mark Jackson" wrote in message
...
Hello,
I have this formula in cell Q194: =(P194*H194)+H194 When there is no data
in P194 this is shown in Q194 #VALUE! How can I hide this? Any help is
appreciated.
Mark
|