Posted to microsoft.public.excel.misc

cjpal

external usenet poster

Posts: 3

IF OR formula not working

the formula below is working unless results in an error (esp. #N/A)...

IF(OR(ISERR((G39/D39)*H39),(G39/D39)*H39=0),"-",(G39/D39)*H39)

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
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
Working Hours (formula & graph) - any elegant solution?	markx	Excel Worksheet Functions	1	March 29th 06 02:02 PM
Array Formula Not Working with Range with Formulas	[email protected]	Excel Discussion (Misc queries)	4	February 1st 06 02:01 PM

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

About Us

"It's about Microsoft Excel"