How can I hide #VALUE!
 

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

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

Hi
depending on your desired result an alternative:
=(N(P194)*H194)+H194

or you may try:
=IF(ISNUMBER(P194),(P194*H194)+H194,"")

--
Regards
Frank Kabel
Frankfurt, Germany
"Mark Jackson" schrieb im
Newsbeitrag ...
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