Results 1 to 4 of 4

Thread: IF formula (XP)

  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    IF formula (XP)

    My question is as follows

    I have a sheet that reconciles amounts from other sheets (see example). I have taken all the links out and reduced it a bit

    When columns E and F have the same amount it will say

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF formula (XP)

    Will F11 be blank, or have a zero in it? As it is right now, it shows a value of zero. This formula should give you the result you're looking for.

    =IF(F11=0," ", IF(F11 = E11, "reconciled", "Warning: Does not balance"))

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF formula (XP)

    Hello Karat,

    You can use this formula (this one is for H11):

    =IF(F11=0,"",IF(E11 = F11, "reconciled", "Warning: Does not balance"))

    It doesn't use a 3rd argument for IF, but two nested IFs instead.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: IF formula (XP)

    Thanks that works like a treat..
    It always looks so simple when you see how to do it....
    Thanks again

Posting Permissions

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