Looking for a user that is good with Microsoft Excel Spreadsheets

@tonialta Golf Handicap NEED a Formula

gross score 77 ( every score over 72 base score ) get 0.2 added = 72.2

gross score 69 ( base score 72 ) 3 under = 3 x 0.2 = 0.6 = 71.4

@ShenaniganFoodie We would also need to need to know the columns that the scores are in.

Let's say name goes in column A and the scores go into column B.

Then the formula, for what I think you want would've something like

=((B1-72)*0.2)+72

So if 77 it would be
((77-72)*0.2)+72
(5*0.2)+72
1+72
73.0

So if 69 it would be
((69-72)*0.2)+72
(-3*0.2)+72
-.6+72
71.4

@sstronaut Thanks, I got the formulas from Nuno

@sstronaut Nuno's formulas doesn't work

* course rating 72 ( b2 )
* handicap 6 ( b4 )

1. Any score over 72 (b2) add 0.2 (b3) to handicap of 6 ( b4 ) = New Handicap (b6) Eg. 6 + 0.2 = 6.2

2. Any score under 72 gets minus 0.2 (b3 ) for every stroke (3x) under 72 (b2) + New Handicap (b6)

Eg. ( 72-69 = 3 x 0.2 (b3) = 0.6) 6 handicap (b4) minus 0.6 = 5.4 ( b6 ) New Handicap

### 2 formulas needed, PLEASE

@ShenaniganFoodie But what cell is the new score being typed in on? And is this just one, or multiple people?

"X?"= the cell number of "Any score"

Any which Excel do you have? I mainly want to make sure it has the IFS function (with the S).

IFS(X?>=B2,((X?-B2)*B3)+B4, X?<B2,((X?-B2)*B3)+B4)

The formula above would go into B6 as I understand your layout. Though a picture might be more helpful if I'm not understanding correctly.

I hope I understood you correctly, and you understand what I mean by the "X?" being the cell number of whatever the new Any score is.

@ShenaniganFoodie

IFS(B6>=B2,((B6-B2)*B3)+B4, B6<B2,((B6-B2)*B3)+B4)