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
|
