Thread: % formula info
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mick Mick is offline
external usenet poster
 
Posts: 35
Default % formula info

Is it possible to write a formula where A1- A100 (eg) is a different money
value. Then I need to find 25% of that value and take it away from values in
column A and insert answer in column B1-B100 (eg).
Then i need to multiply that value by 10% and insert answer in column C1-C100.
Eg: $2.56 x 25% - = $1.92 x 10% = $2.112. This is how I do it on a calculator.
--
Thankyou for your help. Mick