Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
can't change formula or add info.. | New Users to Excel | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
If Info In Cell Then Formula In Another | Excel Discussion (Misc queries) |