bowling-forum.net
The bowlers choice for bowling chat.

Main
Date: 12 Aug 2006 14:47:46
From: wally
Subject: % of handicap
I hope you can help. in cell a1 I have name and a number in this
format: Jones---56. In cell b1 I have another name i.e., Johnson---45.
How can I subtract 45 from 56, take 60% of the difference and in cell
c3 show the following; Johnson---6. All numbers are to rounded down to
0. Thanks for any help.
Wallyb





 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject:


 
Date:
From:
Subject: