This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent for
the results to be in f4.Can someone assist please?

Hmmm

In f4 try

=E4*0.5

Mike

"acss" wrote:

This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent for
the results to be in f4.Can someone assist please?

Another way:

=E4 / 2

Hope this helps.

Pete

On Jun 25, 5:12*pm, acss wrote:
This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent for
the results to be in f4.Can someone assist please?

Ok that works well but curious as to the decimel usage since how do you work
it if 45 percent or 55 percent?

"Mike H" wrote:

Hmmm

In f4 try

=E4*0.5

Mike

"acss" wrote:

This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent for
the results to be in f4.Can someone assist please?

Try this (for 45%)...

=E4-0.45*E4

Of course, that simplifies to =0.55*E4, but I wanted you do see the
subtraction.

Rick


"acss" wrote in message
...
Ok that works well but curious as to the decimel usage since how do you
work
it if 45 percent or 55 percent?

"Mike H" wrote:

Hmmm

In f4 try

=E4*0.5

Mike

"acss" wrote:

This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent
for
the results to be in f4.Can someone assist please?

Hi,

I think a book on basic maths would prove useful

55% multiply by 0.55
45% multiply by 0.45

Mike

"Mike H" wrote:

Hmmm

In f4 try

=E4*0.5

Mike

"acss" wrote:

This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent for
the results to be in f4.Can someone assist please?

acss wrote...
Ok that works well but curious as to the decimel usage since how do
you work it if 45 percent or 55 percent?

=E4*0.55 or =E4*(1-0.45) to reduce by 45%

=E4*0.45 or =E4*(1-0.55) to reduce by 55%

Or you could write these as

=E4*55% or =E4*(100%-45%) to reduce by 45%

=E4*45% or =E4*(100%-55%) to reduce by 55%

This is basic arithmetic.

As you say, simple math, but if you want Excel to do the job for you, try
=E4*(1-45%) or =E4*(1-55%)
--
David Biddulph

"acss" wrote in message
...
Ok that works well but curious as to the decimel usage since how do you
work
it if 45 percent or 55 percent?

"Mike H" wrote:

Hmmm

In f4 try

=E4*0.5

Mike

"acss" wrote:

This is probably the most simplest question;;

I have an amount in e4 and i need that amount subtracted by 50 percent
for
the results to be in f4.Can someone assist please?

"Harlan Grove" wrote ....
This is basic arithmetic.

When I was at school English and Maths were my three worst subjects <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

When I was at school English and Maths were my three worst subjects <g

LOL

Rick