Jim

Posts: n/a

hide #VALUE!

I am using the following formula:

=IF(I71=0,"0%",I71/I74)

I71 has this formula:
=IF(J67=0,"",J67)

When no data shows in I71 I am receiving #VALUE! in the cell that should
return 0%, how can I fix this error?

Thanks

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
hide column	varun	New Users to Excel	1	December 3rd 04 02:13 AM
hide columns	varun	Excel Worksheet Functions	1	December 2nd 04 10:05 AM
AUTO HIDE ROWS	Alan	Excel Worksheet Functions	1	November 27th 04 09:13 AM
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 05:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us