Can someone help with a formula o script - I have present handicaps in column AP - based on whether their present handicap is 16 and over or 16 and below - I need the following to happen based n results in column AU:

if a number in column AU is higher than 70

Present handicap over 16 (column AP) - decrease by 4

Present handicap under 16 (column AP) - decrease by 2

if a number in column AU is less than 30

Present handicap over 16 (column AP)- increase by 4

Present handicap under 16 (column AP) - increase by 2

All rows with a result between 31 an 69 between nothing happens and the handicap in column AP doesn't change

Your help would be very much appreciated

Marc

if a number in column AU is higher than 70

Present handicap over 16 (column AP) - decrease by 4

Present handicap under 16 (column AP) - decrease by 2

if a number in column AU is less than 30

Present handicap over 16 (column AP)- increase by 4

Present handicap under 16 (column AP) - increase by 2

All rows with a result between 31 an 69 between nothing happens and the handicap in column AP doesn't change

Your help would be very much appreciated

Marc

Last edited: