Posted to microsoft.public.excel.misc

Jim

external usenet poster

Posts: 615

Iserror help

Hello,

I have the basic is error formula (=IF(ISERROR(AC21),"",AC21))
What I need help with is in cases where the formula is referencing a cell
that has 0 or blank; how do I write the formula where it will return nothing
if these two items appear?

Thank you

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
Help with ISERROR	juliejg1	Excel Worksheet Functions	2	December 18th 07 01:22 AM
iserror help	Scott@CW	Excel Worksheet Functions	1	December 13th 07 06:03 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	Walshy	Excel Discussion (Misc queries)	3	December 19th 04 05:13 PM

All times are GMT +1. The time now is 04:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us