[solved] Checking values
[solved] Checking values
Hi
Is there a way to have 2 cells in a spreadsheet compared and if they are equal then another cell should show "D" otherwise an error message pops up to say that it should be "D"
cheers Jim
Is there a way to have 2 cells in a spreadsheet compared and if they are equal then another cell should show "D" otherwise an error message pops up to say that it should be "D"
cheers Jim
Last edited by robleyd on Mon Apr 29, 2019 2:29 am, edited 2 times in total.
Reason: Add green tick
Reason: Add green tick
OPenOffice 4.1.1 on Windows 7
Re: checking values
Let's say the two cells you want to be equal are A1 and B1. The formula
will display either D or the message.
Code: Select all
=IF(A1 = B1; "D"; "A1 should equal B1")
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: checking values
oK - I don't want the "D" to show
I need to show that if points are the same it should be a draw, not a win and loss
I have worked around it like this.
entries│ W│ 3│ L │3│ should be │D│3│D│3│
so I created and extra column to the right that puts a "d" there if the points are equal ( being the 3 & 3 in example)
I used the formula =IF(D2=B2;"d";'l')
I made this"l" a valid entry and therefore d an invalid entry so when they move on the another cell a pop-up that says "Should be a draw" pops up
I hide this column
cheers Jim
I need to show that if points are the same it should be a draw, not a win and loss
I have worked around it like this.
entries│ W│ 3│ L │3│ should be │D│3│D│3│
so I created and extra column to the right that puts a "d" there if the points are equal ( being the 3 & 3 in example)
I used the formula =IF(D2=B2;"d";'l')
I made this"l" a valid entry and therefore d an invalid entry so when they move on the another cell a pop-up that says "Should be a draw" pops up
I hide this column
cheers Jim
OPenOffice 4.1.1 on Windows 7
Re: checking values
I can make the Ws and Ls turn red if they should be a "D"
OPenOffice 4.1.1 on Windows 7
Re: checking values
Use the "Conditional Format" feature of the calc. You can set some conditions and user defined cellstyles to apply in the settings of the CF function.I can make the Ws and Ls turn red if they should be a "D"
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: checking values
Are you wanting to change the W/L to a D if the numbers beside them are the same? If so, then you are out of luck, with the exception of (maybe) a macro., since a cell can not contain an entry (W/L) and a formula (to display D if the numbers are equal).
If the W/L/D can be done as a formula, based on the numbers beside the letters, then here's my suggestion:
1) The letter/number combination are in 4 different columns (I'm going to use A-D)
2) The letters are in the 1st and 3rd columns, thus making the numbers in the 2nd and 4th.
3) In A1 enter
4) In C1 enter
Adjust the row and column numbers for your spreadsheet.. without knowing the actual layout, I can't give a code that will not need modification.
If the W/L/D can be done as a formula, based on the numbers beside the letters, then here's my suggestion:
1) The letter/number combination are in 4 different columns (I'm going to use A-D)
2) The letters are in the 1st and 3rd columns, thus making the numbers in the 2nd and 4th.
3) In A1 enter
Code: Select all
=if(B1=D1;"D";if(B1>D1;"W";"L"))
Code: Select all
=if(A1="D";"D";if(A1="W";"L";"W"))
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Checking values
hi Russell = making the W & L turn red is enough of a warning. Just because the points values are the same doesn't necessarily mean they are correct. Someone may have added them up worng. The red warning makes the scores look at the score card to see what it really should be. Changed to D automatically is an option as you say, but it needs to be checked first.'Thanks Jim
OPenOffice 4.1.1 on Windows 7
Re: Checking values [solved]
A spreadsheet would not suffer from this problemSomeone may have added them up worng.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers