'of' percentage with calculation
 

Hi,

I'm not very good with math...

I'm trying to achieve a cell that divides a cell number by 2 and then shows
20% €˜of the original.

e.g. this - 564.29 €“ to this - 225.72

I can do it in 2 cells using lots of brackets but cant figure the calc out
in one cell.

Thanks

'of' percentage with calculation
 

Hi,

You can use something like this if you have 546.29 in A1

=(A1-(A1*0.2))/2

Regards,
Bondi

'of' percentage with calculation
 

Code:
--------------------

=a21/2-((a1/2)*0.2)



--------------------


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=544202