**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

Please review the formula.

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

Please refresh the browser.

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

Your reference deal with strings.

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.*