1. ## IF formula, but a paradox

Is there such a formula that is a sort of paradox ?
For example;

Variable Value in O3 changes constantly, ( Descending, from 300 to -100 )

Fixed Value in A9 is 100
In cell D9 formula is:
=IF(\$A\$9>=\$O\$3,1,"0")

Fixed Value in A10 is 50
In cell D10 formula is
=IF(\$A\$10>=\$O\$3,1,"0")

Currently when Descending Value in O3 reaches 100, it will show 1 in D9, OK
And when Value in O3 reaches 50, respectively it will show 1 in D10, OK

The paradox is, when D10 is 1, can the same Formula in D9 be made so Value in D9 goes back to 0 when D10 is showing 1 ?

Thanks

2. Can this be D9: =IF(\$D\$10=1,0,IF(\$A\$9>=\$O\$3,1,0))

3. XPD,

D9 = =IF(\$D\$10=1,0,IF(\$A\$9>=\$O\$3,1,"0")) HTH

Kevin beat me to the enter key...
BTW: I noticed Kevin took the quotes off of the 0 value did you really want them there? I let them stand as I didn't know and you did type it more than once.

4. I'll test it over the next few days, and then there is a 3rd paradox.
It's a tricky one, I'm not sure myself yet. Have to run some tests.

Thanks.

5. ..or a slightly shorter formula
[D9]=--AND(\$A\$9>=\$O\$3,\$O\$3>\$A\$10)
..provided you don't actually really want a 'text' value for the zero result as RG notes in his reply

zeddy

6. ## Solved

Thanks,

No quotes, I think it was habit...wasn't thinking, temporary loss of ... I don't know why I added quotes, not guilty!
No Quotes...

Tested it, and worked OK. ( with no quotes)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•