percentages
 

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

I dont get it... its probibly the most simple function... but I cant
figure it out. 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

johnsmith Wrote:
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


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=396203

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


--
johnsmith
------------------------------------------------------------------------
johnsmith's Profile: http://www.excelforum.com/member.php...o&userid=26355
View this thread: http://www.excelforum.com/showthread...hreadid=396203

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