Mark a value in a cell IF a value in another is x...

HI,
i need some help with a (probably) easy task for you guys.. i'm very poor at Excel to be honest.

What i need to set is a value in a specific cell that depends on the value marked in another cell.

Example: football match result:

Team A VS Team B: 3-1. Team A wins so the result is: 1 (could be either X for a draw or 2 in case of an away win), so depending IF the value in the cell is 1, X or 2 i need to "translate" this into a numeric value in another cell and build up a dynamic classification.

so excel should read the value in the first cell (IF 1, X or 2) and associate a numeric value to it, such as 0, 1 or 3 (points) in a DIFFERENT cell.

Not sure i made myself clear.. any idea?

mhhh.. might work.. now i just probably need to add the option IF A3=B3;1 in case of a draw. I'll try it.
Thanks

HI ,

Provide a sample work book
Punnam

ok.. it's not working but please have a look into what i want to achieve :-S

Excel prob.png

i think i can see 2 ways of doing this:

1) to compare the 2 cells with the actual goals value and give instruction to mark a number in the Match 1 cell

2) to READ the value 1,X or 2 and Translate it into a numeric value in the Match 1 cell

:-S

here teh file sample editable:

https://docs.google.com/spreadsheets...yG8/edit#gid=0

I managed to have Excel accepting this formula, but the result is: #NAME?

Basically i have to mark a different value (3,1 or 0) in my target cell depending on the values (1,x or 2) of the my source cell, but it doesn't work.
The forlmula is:
=IF(A=1,3)*OR,IF(A=x,1)*OR,IF(A=2,3)

Any ideas?

Hi Nabarez ,


Provide a sample work book stating your requirement as before and after sheet for better understanding & fast response.

Punnam

is this one working?

https://docs.google.com/spreadsheets...yG8/edit#gid=0

hi Nabarez,

It is showing a connecting error .

Punnam