FORMULAS and FUNCTIONS

Copper Contributor

I need to start over, and I copied a portion of my file.

We us a base of 90% of 210 to handicap our bowlers.  

 BOWLERS NAMES

CORR

HDCP

AVGHDCPGAME 1TOTAL 1HDCPGAME 2TOTAL 2HDCPGAME 3TOTAL 3SERIES
1YOLANDA SULLIVANW4715719.8150150.04720024747189236633.0
2KEVIN RICKSM1918819.8200219.81920122019210229668.8
3DANNINE PRITCHARDW4615846.8         
4MARTHA WILLIAMSW5514846.8         
5WILLIAM MAHONEYM4615838.8         
6TERESINA MAHONEYW5115351.3         
7AUDREY JACKSONW6313963.9         
8LEON CADILLM2418324.3         
9ELVIN WALKERM3916639.6         
10DORA McKINNEYW6214162.1         
11LOUISE FOBBSW6413864.8         
12RICH ALLENM2618119.8         
13LESLIE HOFMIREW2518219.8         
14LEONARD PEDERNALM2418319.8         
15PHYLLIS McDONALDW1918819.8         

Base 210 minus bowlers average, 188 = 22 x 90% =19.  Can't copy and paste.

1 Reply

@LEEWOOL 

=ROUNDDOWN((210-E3)*0.9,0)

Maybe with this formula.

bowling.JPG