Tweet
=(abs(A1-B1)/abs(A1))*100
-
Play hangman. -
Still no good
I need a absolute score based on how close A1 is to B1.
When A1=200 and B1=300 then C1 =?
When A1=200 and B1=100 then C1 = ?
Also
When A1=20 and B1=30 then C1 =?
When A1=20 and B1=10 then C1 = ?
All four examples need to give the same value in C1
Am I not explaining this very well?
Comment
-
How does chaunk's solution not work?
ABS(200-300)/ABS(200) = .5 (50%) [100/200]
ABS(200-100)/ABS(200) = .5 (50%) [100/200]
ABS(20-30)/ABS(20) = .5 (50%) [10/20]
ABS(20-10)/ABS(20) = .5 (50%) [10/20]
I think ABS(A1-B1)/ABS(A1) is correct. (The *100 is not needed if you format it as a %)<Reverend> IRC is just multiplayer notepad.
I like your SNOOPY POSTER! - While you Wait quote.Comment
-
Well chaunks formula should do it. Or you're not explaiing very well
Originally posted by Serb:Please, remind me, how exactly and when exactly, Russia bullied its neighbors?
Originally posted by Ted Striker:Go Serb !
Originally posted by Pekka:If it was possible to capture the essentials of Sepultura in a dildo, I'd attach it to a bicycle and ride it up your azzes.Comment
-
Njet, du nichts forklarer it mucho gut. Cannst you nicht putzen some numre in the pozitione of spørgsmålstegn ?Originally posted by reds4ever
Am I not explaining this very well?
With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.
Steven WeinbergComment
-
If you need an excel file that does the above, let me know, as i've just created one ... but just entering above formula is all i did
<Reverend> IRC is just multiplayer notepad.
I like your SNOOPY POSTER! - While you Wait quote.Comment
-
No, you're not...chaunk answered your question according to your description...although personally, rather than multiply by 100, I would just display the value as a percentage for that cell.Speaking of Erith:
"It's not twinned with anywhere, but it does have a suicide pact with Dagenham" - Linda SmithComment
-
Thats it, cheers all. I think I'd lost the plot near the end, sorry chaunk!!Comment
Comment