Posted to microsoft.public.excel.misc

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

Nested If not returning correct values

Try this:

=IF(N(G18),IF(T18/G180,T18/G18,"NA"),"NA")

"murkaboris" wrote:

Hello:

I have the following formula:
=IF((T18/G18<=0),"NA",IF(ISERROR(T18/G18),"NA",T18/G18))

It returns the correct values outside of the "ISERROR" section -- so when
there is a division by "0" it gives you the standard "#DIV/0!" which I want
to be replaced by "NA".

Can you please review the formula and tell me what might be wrong that it
still keeps it as "#DIV/0!"?

Thank you.
Monika

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
Vlookup not returning correct value	Drebdog	Excel Worksheet Functions	4	August 6th 08 11:29 PM
Match formula not returning correct values.	pm	Excel Discussion (Misc queries)	1	January 30th 08 03:15 PM
MAX Function not returning correct value	Phil	Excel Worksheet Functions	4	April 28th 06 10:14 PM
VLOOKUP not returning correct value	leigh	Excel Worksheet Functions	6	October 13th 05 12:22 PM
Vlookup not returning correct value	Mandy Brookes	Excel Worksheet Functions	1	January 26th 05 12:12 PM

All times are GMT +1. The time now is 02:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us