Simple Math

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

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?
 
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
 
Hi,

I think a book on basic maths would prove useful

55% multiply by 0.55
45% multiply by 0.45

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

=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%)
 
Harlan Grove said:
This is basic arithmetic.
Click to expand...

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
When I was at school English and Maths were my three worst subjects <g>

LOL

Rick
 
Back
Top