# Basic IF function

1. ## 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:  `Please Login or Register  to view this content.`  Register To Reply

2. ## Re: Basic IF function

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

3. ## Re: Basic IF function Originally Posted by Glenn Kennedy 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  Register To Reply

4. ## Re: Basic IF function

You're welcome...  Register To Reply