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

Thanks

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

=A1 / 2 * 0.8

Hope this helps.

Pete

=A1*40%

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Pete_UK" wrote in message
oups.com...
Assuming your value is is A1, enter this in B1:

=A1 / 2 * 0.8

Hope this helps.

Pete

probably should be

=ROUND(A1*40%,2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Pete_UK" wrote in message
oups.com...
Assuming your value is is A1, enter this in B1:

=A1 / 2 * 0.8

Hope this helps.

Pete

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

Pete