Posted to microsoft.public.excel.programming

sungen99[_115_] sungen99[_115_] is offline

external usenet poster

Posts: 1

Error handling question

I use this formula
=AG31/ABS(O33)

Sometimes I get an “#VALUE!” error. All I want to do is to show the
result of =AG31/ABS(O33) OR show “”.

Anyone please?

--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=549074

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Error handling question	colofnature[_56_]	Excel Programming	0	June 6th 06 05:38 PM
Error handling question	sungen99[_114_]	Excel Programming	0	June 6th 06 05:28 PM
Look up error handling question.	sungen99[_104_]	Excel Programming	4	May 12th 06 04:23 PM
Error Handling question	BigPig	Excel Programming	4	March 19th 06 08:00 PM
question error handling	Pierre via OfficeKB.com[_2_]	Excel Programming	3	November 7th 05 09:39 PM

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

About Us

"It's about Microsoft Excel"