Thread: The Maths Thread
View Single Post
Old 27-12-2012, 04:43 AM   #574 (permalink)
weldone
International Captain
 
weldone's Avatar
 
Join Date: Jan 2008
Location: Kolkata --> Mumbai, India
Posts: 5,950
Quote:
Originally Posted by Days of Grace View Post
How do I enter that into the formula input?
Average Points
20 160
40 80
10 320

Suppose, averages are in column A and Points are in column B, then in cell B2 write this:
=3200/A2

Copy B2 and paste in B3, B4 etc...
__________________
"I want to raise my hand and say one thing. Those who complain about my love for the game or commitment to the game are clueless. These are the only 2 areas where I give myself 100 out of 100."
- Sachin Tendulkar, as told in an interview published in Bengali newspaper Anandabazar Patrika after his 100th International century (translated by weldone)
weldone is offline   Reply With Quote