Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Dear,
I need to calculate the below in excel sheet. please find below the details and advise me: Amount - 25000 - 3% * 3% please advise how to subtract 3% from 25000 and then calculate 3% of that amount. awaiting for your earliest response. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Hi Shona,
3% is actually 3 hundreths or 0.03. Therefore formula is. =(25000-0.03*25000)*0.03 Standard maths rules apply inside brackets are first, multiplication is before add or subtract. -- Regards, OssieMac "Shona" wrote: Dear, I need to calculate the below in excel sheet. please find below the details and advise me: Amount - 25000 - 3% * 3% please advise how to subtract 3% from 25000 and then calculate 3% of that amount. awaiting for your earliest response. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
"Shona" wrote:
please advise how to subtract 3% from 25000 and then calculate 3% of that amount. =25000*(1-3%)*3% which is the same as: =(25000 - 25000*3%)*3% ----- original message ----- "Shona" wrote: Dear, I need to calculate the below in excel sheet. please find below the details and advise me: Amount - 25000 - 3% * 3% please advise how to subtract 3% from 25000 and then calculate 3% of that amount. awaiting for your earliest response. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Thank You
"OssieMac" wrote: Hi Shona, 3% is actually 3 hundreths or 0.03. Therefore formula is. =(25000-0.03*25000)*0.03 Standard maths rules apply inside brackets are first, multiplication is before add or subtract. -- Regards, OssieMac "Shona" wrote: Dear, I need to calculate the below in excel sheet. please find below the details and advise me: Amount - 25000 - 3% * 3% please advise how to subtract 3% from 25000 and then calculate 3% of that amount. awaiting for your earliest response. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) |