'of' percentage with calculation (attempt 2)

S

Steve Crowther

Hi,

I'm not very good with math...
(and not too hot with English either, based on pervious post)

I'm trying to achieve a cell that divides a cell number by 2 and then shows
20% ‘off’ the result (minus 20%).

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
 
P

Pete_UK

Assuming your value is is A1, enter this in B1:

=A1 / 2 * 0.8

Hope this helps.

Pete
 
B

Bob Phillips

probably should be

=ROUND(A1*40%,2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
P

Pete_UK

Yes, Bob, I thought the OP might understand it more easily written out
in longhand!

Pete
 
Top