how to calculate percentages between columns

asked 2019-10-07 23:02:41 +0100

MarkN gravatar image

I'm trying to calculate batting averages in calc

edit retag flag offensive close merge delete

Comments

Would you be able to get what OP is asking without having your own idea in mind (i.e. by just reading the written words in this "question") ?

Opaque gravatar imageOpaque ( 2019-10-07 23:45:51 +0100 )edit

Unfortunately yes. Only because did this often when younger. It is simply Hits / AB (at bats) to 3 decimal places.

Therefore A1 = AB; B1 = Hits and formula in C1 is =B1/A1 formatted to three decimal places.

Also it's a matter of where you live as to what 'batting averages' relates to - American Pastime. Live it all summer long.

Ratslinger gravatar imageRatslinger ( 2019-10-08 00:08:51 +0100 )edit

??? - this sounds like some insider thing, will leave it ...

Opaque gravatar imageOpaque ( 2019-10-08 00:35:11 +0100 )edit

Sorry, should have been a bit more specific - the sport of Baseball. And I shouldn't neglect there are other countries where this proliferates such as Japan.

Ratslinger gravatar imageRatslinger ( 2019-10-08 01:04:54 +0100 )edit