percentages

[johnsmith]

Confused...

i can not seem to get the sum of $33.00 - 7% (it equals $30.69) how do i do that on an excel worksheet?

please help....

[johnsmith]

I dont get it... its probibly the most simple function... but I cant figure it out. Please Help

[Paul Sheppard]

I dont get it... its probibly the most simple function... but I cant figure it out. Please Help

Hi John

If the $33.00 is in cell A1 use this formula in B1 =A1*(100-7)/100

Paul

[johnsmith]

Thank you so very much Paul!!! I feel so stupid because I am not very good at excel. You are a lifesaver!!!

[StinkeyPete]

If the $33.00 is in cell A1 use this formula in B1 =A1*(.93)



"johnsmith" wrote:

>
> Confused...
>
> i can not seem to get the sum of $33.00 - 7% (it equals $30.69) how
> do i do that on an excel worksheet?
>
> please help....
>
>
> --
> johnsmith
> ------------------------------------------------------------------------
> johnsmith's Profile: http://www.excelforum.com/member.php...o&userid=26355
> View this thread: http://www.excelforum.com/showthread...hreadid=396203
>
>