Not quite as elegant but you can do it in one cell
a1: £8.75
a2: =((a1/100)*80)
alternativly
if the % deduction changes
a1: Percentage to deduct eg. 20% 30% etc..
a2: Amount eg. £8.75, £9.15 etc
cell b1: = (($a$2/100)*$a$1)
Or if the amount changes
Col C= Amount eg c1 £8.75
Col D = ((c1/100)*$a$1)
You can then drag the formula down column D
For this one keep the format of cell A1 as a number NOT Percentage.
Remember you can use the F4 key to lock the absolute references.
Hope this helps.
DaveA
This message was edited by applebyd on 2002-08-28 04:50