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?