Thread: Excel Formulas
View Single Post
  #2  
Old April 26th, 2010, 07:14 AM posted to microsoft.public.excel.worksheet.functions
OssieMac
external usenet poster
 
Posts: 862
Default 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.