Mark Jackson

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - hide erroer values	Kathrine J Wathne	Excel Discussion (Misc queries)	1	January 10th 05 10:13 PM
Checkbox to hide and unhide rows Please.	Steved	Excel Worksheet Functions	2	December 6th 04 11:30 PM
hide columns	varun	Excel Worksheet Functions	1	December 2nd 04 10:05 AM
Excel - if cells = 0, how to conditionally hide rows in chart	fineimage	Excel Worksheet Functions	1	November 11th 04 09:45 PM
Conditional Hide function for Excel	mr.woofies	Excel Worksheet Functions	1	October 28th 04 03:04 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us