Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If formula Help (2003)

    I have two fields - Current and Previous. I would like to create a calculated column where if Current and Previous are the same then Current, If current and Previous are different then "transfer", IF Current is Null then "Lost", If Previous is Null then "Gain". My formula works except Where one of the fields is null it thinks it is a "Transfer" because they are different. I tried this
    =IF(AG2=AH2,AG2,IF(AG2<>AH2 and AG2 Not Null and AH2 Not Null,"Transfer",IF(AG2 is Null,"Lost",IF(AH2 is Null,"Gain"))))
    Of course my syntax is way off. Any help would be appreciated.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If formula Help (2003)

    I figured it out -
    =IF(AG2=AH2,AG2,IF(AG2 ="","Lost",IF(AH2 ="","Gain","Transfer")))

Posting Permissions

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