Posted to microsoft.public.excel.misc

Andrew

external usenet poster

Posts: 358

Inconsistent Formula?

I have the following formula:

=IF((AND(ISNUMBER(T7),N7="H",T7=0)),"x",(IF(AND(IS NUMBER(T7),N7="H",T7<0),"R","")))

The formula above is able to provide a result, but I keep getting the
'triangle tab' on the top left of the cell saying that this is inconsistent.
Due to this, it has also affected my other formula cells - some which
returned "Value Not Available" error.

Any ideas?

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
Strange and inconsistent result from a simple formula	Jack Sadie	Excel Worksheet Functions	9	May 15th 07 05:39 PM
Inconsistent Sorting	Saxman	Excel Discussion (Misc queries)	17	October 23rd 06 11:17 AM
Formula results inconsistent.	CyberTootie	Excel Worksheet Functions	3	October 15th 06 03:20 PM
Help! ISO formula for inconsistent monthly dates	Yeah	Excel Discussion (Misc queries)	11	August 27th 06 03:32 AM
3-d referencing inconsistent	duncan79	Excel Discussion (Misc queries)	5	January 25th 06 05:39 PM

All times are GMT +1. The time now is 05:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us