View Single Post
  #5   Report Post  
Posts: n/a

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!)
to email me remove the obvious!