# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula to return 3 if value in column A is equal to value in column B and return 1 if value in column A is greater than value in column B
Solved by B. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 19/06/2018 - 02:28
Hi
Excelchat Expert 19/06/2018 - 02:28
Welcome to Got It Pro.
User 19/06/2018 - 02:28
hello
Excelchat Expert 19/06/2018 - 02:28
You are looking for nested if formula for 2 conditions?
User 19/06/2018 - 02:29
in fact I have 3 conditions
User 19/06/2018 - 02:29
let me explain it more details
Excelchat Expert 19/06/2018 - 02:29
What is the value for A<B?
User 19/06/2018 - 02:29
for example you can imagine you are guessing the result of a football match
Excelchat Expert 19/06/2018 - 02:29
ok.
User 19/06/2018 - 02:30
if your guess is perfect with the final result then you have 3 points
User 19/06/2018 - 02:30
if you only correct about which team win, you get 1 point, otherwise is 0
Excelchat Expert 19/06/2018 - 02:30
ok.
Excelchat Expert 19/06/2018 - 02:31
=if(A1=B1,3,if(A1>B1,1,0))
User 19/06/2018 - 02:31
so you have the actual result in column A and your guess in column B. I need the point in column C
User 19/06/2018 - 02:32
for example in column A is 2-1, if column B is 2-1 then C = 3
Excelchat Expert 19/06/2018 - 02:32
User 19/06/2018 - 02:32
if column B is 3-0 then C = 1
User 19/06/2018 - 02:32
if column B is 2-2 or 1-3 then C = 0
Excelchat Expert 19/06/2018 - 02:33
I have added the formula in C1 cell.
Excelchat Expert 19/06/2018 - 02:33
"-" is considered AS STRING.
Excelchat Expert 19/06/2018 - 02:39
Values are compared as shown in the preview.
Excelchat Expert 19/06/2018 - 02:40
Please visit Got It Pro for new queries.
User 19/06/2018 - 02:40
I cannot see the preview :(
User 19/06/2018 - 02:41
could you send me as a file please
Excelchat Expert 19/06/2018 - 02:41
User 19/06/2018 - 02:42
it seems that my company policy blocks google docs
Excelchat Expert 19/06/2018 - 02:42
Ok. Please enter 2 in A1 cell.
Excelchat Expert 19/06/2018 - 02:42
1 in B1 cell.
Excelchat Expert 19/06/2018 - 02:42
=if(A1=B1,3,if(A1>B1,1,0))
Excelchat Expert 19/06/2018 - 02:42
Enter this formula in C1 cell.
User 19/06/2018 - 02:45
thank you but it does not solve the the formula in my example
Excelchat Expert 19/06/2018 - 02:46
Excelchat Expert 19/06/2018 - 02:46
The string contain "-"
Excelchat Expert 19/06/2018 - 02:46
However, you results are based on the first part of the string.
Excelchat Expert 19/06/2018 - 02:46
It is before "-"

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.