General Betting
There is currently 1 person viewing this thread.
07 Jan 12
22:19
Joined:
Date Joined:
12 Apr 08
I have a soccer score in excel which I am updating manually.
Team A's score in cell [A1]. Team B's score in cell [B1].
How do I make a formula in [C1] which automatically will; Turn [C1] into either 1 if [A1] is higher than [B1], turn [C1] into X if [A1] is equal to [B1] and turn [C1] into 2 if [A1] is less than [B1].
Have tried again and again from google/website w/o luck..
Could one of you with excel-knowledge please advise?
Much appreciated..
Team A's score in cell [A1]. Team B's score in cell [B1].
How do I make a formula in [C1] which automatically will; Turn [C1] into either 1 if [A1] is higher than [B1], turn [C1] into X if [A1] is equal to [B1] and turn [C1] into 2 if [A1] is less than [B1].
Have tried again and again from google/website w/o luck..
Could one of you with excel-knowledge please advise?
Much appreciated..
sort by:
Show
per page
Replies: 16
|
By:
The below should work:
=IF(A1>B1,"1",IF(A1=B1,"X","2")) |
|
By:
Hi dave b,
Thank you for the above which I am sure is right. However when I enter the above, I am being told that my formula contains and error (and the B1,"1", part is marked. I have no idea why I can't get it to work - as I am using a 'new sheet'. |
|
By:
Not sure why it's not working. I have copied and pasted the above formula into Excel and it works fine for me.
|
|
By:
Is one of you seeing the greater than sign, and one of you not seeing it?
Between A1 and B1 is a greater than sign that shows up in dave's posts and not Man's posts. |
|
By:
Ah, that would be it Lori. I remember this forum has problems with the 'greater than' sign.
|
|
By:
Hmm.. I enter in C1: =IF(A1>B1,"1",IF(A1=B1,"X","2")) after having entered the number 2 in cell A1 and the number 1 in cell B1.
I then thought that there would be either 1, X or 2 in C1. But there's only the formula.. written in C1? |
|
By:
Hmm.. I enter in C1: =IF(A1>B1,"1",IF(A1=B1,"X","2")) after having entered the number 2 in cell A1 and the number 1 in cell B1.
I then thought that there would be either 1, X or 2 in C1. But there's only the formula.. written in C1? |
|
By:
Right click on C1 and "format cell"
See if it's set to "general", if it's not, set it to that. |
|
By:
If that doesn't work click on C1 then go to Tools then Options and make sure the Formulas box is not checked.
|
|
By:
Thank you both.
I found out just now that I needed to call formula; =IF(A1>B1;("1");IF(A1=B1;("X");("2"))) Maybe just my setup - but seems to work now, thank you a lot! |
|
By:
I just copied and pasted your formula into Excel and it comes back as text!? As long as it works for you. Cheers.
|
|
By:
dave b / Lori; Is one of you able to solve my final question;
I have the following in Cell A1; [3] goals. In Cell B1; [2] goals - which then result in my Cell C1 showing a [1] due to our formula above. In Cell [D1], [E1] and [F1]... i have guessed/staked the following outcomes of the match, respectively: 1 [in D1] X [in E1] and [F1 is empty). Using conditional formatting, do you know which formula I should insert in order for the [D1], [E1] or [F1] to be highlighted green in those cases where these three cells are containing (I have bettet the same) that corresponds/is equal to the [C1] ? |
|
By:
ie Cell [D1] will light up green if it contains the same content [1] as Cell [C1].
|
|
By:
found it, thx
|
|
By:
It probably depends on which version of Excel you're using as to whether this next bit works.
There's a tab at the top called conditional formatting in excel 2007 click on D1 and then click on that tab. Select "Highlight cell rules" from the drop down that appears and then "Equal to". A popup box appears, with a gap and a drop down which starts on "Light Red Fill with Dark Red Text". Click on C1 to fill the gap, and then hit ok. that will give you red text... I'm sure you can play around to work out the green bit :) |
|
By:
I am guessing that dave b's formula he supplied for the original question did not work because the op's
Excel is using a language that is not English. The English uses a comma as a parameter/argument separator and some other languages use a semi-colan. If he wishes to change to a comma separator this is how to do it. http://digilander.libero.it/foxes/Excel/Excel_How_to_change_the_argument_separator.htm Cheers. |