Results 1 to 4 of 4

Thread: IF Statement

  1. #1
    New Lounger
    Join Date
    May 2008
    Location
    Albuquerque, New Mexico, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If I have in column E either a YES or a NO. now in column F I want if Yes then display "No Audit" and if No (in column E) then in column F it would read "Audit"...

    I know this is simple enough, I just cant seem to get it to work

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Try this .....
    =IF(E1="Yes","No Audit", "Audit")

  3. #3
    New Lounger
    Join Date
    May 2008
    Location
    Albuquerque, New Mexico, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What if the cell is blank?

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    What do you want to show if the cell is blank?

    Are there any other possibilities besides YES, NO, and blank?

Posting Permissions

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