View Single Post
  #4   Report Post  
Gordon
 
Posts: n/a
Default

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!