'of' percentage with calculation

[Steve Crowther]

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 can’t figure the calc out
in one cell.

Thanks

[Bondi]

Hi,

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

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

Regards,
Bondi

[bgeier]

Please Login or Register  to view this content.