Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Nov 2011
    Location
    Australia
    Posts
    221
    Thanks
    80
    Thanked 3 Times in 2 Posts

    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. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Can this be D9: =IF($D$10=1,0,IF($A$9>=$O$3,1,0))

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    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.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    3 Star Lounger
    Join Date
    Nov 2011
    Location
    Australia
    Posts
    221
    Thanks
    80
    Thanked 3 Times in 2 Posts
    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. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    ..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. #6
    3 Star Lounger
    Join Date
    Nov 2011
    Location
    Australia
    Posts
    221
    Thanks
    80
    Thanked 3 Times in 2 Posts

    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
  •