Posted to microsoft.public.excel.programming

Phil Hageman[_3_] Phil Hageman[_3_] is offline

external usenet poster

Posts: 160

=IF(ISERROR) doesn't work

I have three conditional formats on a cell:

1. Cell value is less than 0 (it works)
2. Formula is =(B10="") (it works)
3. Formula is =IF(ISERROR) (doesn't work)

I've tried various combinations to get number 3 to work -
can someone suggest a fix?

Thanks,
Phil

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
IF iserror does not work	Wanna Learn	Excel Discussion (Misc queries)	8	May 19th 08 07:09 PM
Iserror does not work for missing sheets in linked file	[email protected]	Links and Linking in Excel	1	June 13th 07 06:31 PM
Iserror & VBA	Ken G.	Excel Discussion (Misc queries)	1	February 28th 06 11:37 PM
ISERROR - #NAME?	Mpaul	Excel Worksheet Functions	2	February 20th 06 10:27 PM
ISERROR Functin to Much Work!	ExcelMonkey	Excel Worksheet Functions	2	November 12th 04 08:47 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us