% 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 |
% 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