Thread: Excel Formulas
View Single Post
  #3  
Old April 26th, 2010, 07:26 AM posted to microsoft.public.excel.worksheet.functions
Joe User[_2_]
external usenet poster
 
Posts: 757
Default 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.