|
|
Quote:
Originally Posted by 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!
|
Nevermind, I got it. I had it backwards, this post helped me out: http://www.excelbanter.com/showthread.php?t=217651.
It's this:
Code:
=IF(OR(
AND(VALUE(H10)=0,VALUE(H10)<=59, VALUE(H10-G10)=0.06),
AND(VALUE(H10)=60,VALUE(H10)<=74, VALUE(H10-G10)=0.05),
AND(VALUE(H10)=75,VALUE(H10)<=84, VALUE(H10-G10)=0.04),
AND(VALUE(H10)=85,VALUE(H10)<=92, VALUE(H10-G10)=0.03),
AND(VALUE(H10)=93,VALUE(H10)<=96, VALUE(H10-G10)=0.02),
AND(VALUE(H10)=97,VALUE(H10)<=99, VALUE(H10-G10)=0.01)),"Y","N")
|