JE McGimpsey wrote:
Since 100% is equal to one, 15% off can be represented as 100%-15%, or
1-15%, so if your retail price is in column A:
B1: =A1 * (1-15%)
S/be =A1 * (1-0.15)
--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(9 days and counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
|