About Us

KeriM

I have a pretty complicated IF statement, and I'm trying to put an "OR" around all my IF's and I'm getting a #Value. I tried to break it up for you guys...

Code:

=OR

(IF(AND(VALUE(H10)=0,VALUE(H10)<=59, VALUE(H10-G10)=0.06),"Y","N"),

(IF(AND(VALUE(H10)=60,VALUE(H10)<=74, VALUE(H10-G10)=0.05),"Y","N")),

(IF(AND(VALUE(H10)=75,VALUE(H10)<=84, VALUE(H10-G10)=0.04),"Y","N")),

(IF(AND(VALUE(H10)=85,VALUE(H10)<=92, VALUE(H10-G10)=0.03),"Y","N")),

(IF(AND(VALUE(H10)=93,VALUE(H10)<=96, VALUE(H10-G10)=0.02),"Y","N")),

(IF(AND(VALUE(H10)=97,VALUE(H10)<=99, VALUE(H10-G10)=0.01),"Y","N")))

They work invidually and give me either a "Y" or "N", but it just doesn't like that OR around all of them. I need to test cell H10 against all these conditions to see where it falls. Any help is appreciated! Thanks!

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
nested if statements using "AND" as well as "OR"	ibbm	Excel Worksheet Functions	3	January 23rd 09 08:17 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM
Nested "IF" With "And"and "OR" functions	Richard Freist	Excel Worksheet Functions	3	February 3rd 07 03:04 PM
Need more than 7 nested "IF" statements in Excel"	James A	Excel Discussion (Misc queries)	1	December 17th 06 02:02 AM
nested "with .../end with" statements	mark kubicki	Excel Programming	2	February 25th 04 11:34 PM

Menu

About Us