ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   % formula info (https://www.excelbanter.com/excel-worksheet-functions/240498-%25-formula-info.html)

Mick

% 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

T. Valko

% 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





All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com