Thread: % formula info
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default % formula info

Try this:

A1 = 2.56
B1 formula: =A1*0.75
C1 formula: =B1*1.1

--
Biff
Microsoft Excel MVP


"Mick" wrote in message
...
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