+ Reply to Thread
Results 1 to 4 of 4

Basic IF function

  1. #1
    Registered User
    Join Date
    12-28-2014
    Location
    Tripoli
    MS-Off Ver
    2007
    Posts
    2

    Basic IF function

    Hi,

    Basic IF function but I can't seem to work it out, so help is much appreciated.

    I have A1=50 and A3=70. My If function will compare both A1 and A3, if both figures are the same then cell A4 will display “Correct”, if not, then cell A4 will display “Incorrect” and will tell me the difference which is A3- A1. My problem is I didn’t know how to display both “Incorrect” and “A3- A1” in the same cell. Here is my formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: Basic IF function

    You were nearly there...
    =IF(A1=A3,"Correct",IF(A1<>A3,"Incorrect, difference is "&A3-A1 ))
    Glenn



  3. #3
    Registered User
    Join Date
    12-28-2014
    Location
    Tripoli
    MS-Off Ver
    2007
    Posts
    2

    Re: Basic IF function

    Quote Originally Posted by Glenn Kennedy View Post
    You were nearly there...
    =IF(A1=A3,"Correct",IF(A1<>A3,"Incorrect, difference is "&A3-A1 ))
    Brilliant, concatenate solved it and it works as I want it. Thank you

  4. #4
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: Basic IF function

    You're welcome...

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Basic If Function problem
    By MelodyK in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-28-2014, 06:37 PM
  2. Help with a basic function
    By Rhuumz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 02:05 AM
  3. Using IF function and a VLOOKUP in VBA - Basic uses
    By ste_mulv in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2009, 05:45 AM
  4. I need a basic function
    By Elizabeth.gall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2008, 02:43 PM
  5. Basic IF function
    By Intern in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2007, 12:44 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1