Prev: �como puedo conbinar formulas entre hojas de exel ?
Next: limit comments to only 600 words
From: Shona on 26 Apr 2010 01:58
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.
From: OssieMac on 26 Apr 2010 02:14
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.
From: Joe User on 26 Apr 2010 02:26
"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.
From: Shona on 26 Apr 2010 02:38
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.
 | 
Pages: 1
Prev: �como puedo conbinar formulas entre hojas de exel ?
Next: limit comments to only 600 words