software

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

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)

quot;Pete_UKquot; gt; wrote in message oups.com...
gt; Assuming your value is is A1, enter this in B1:
gt;
gt; =A1 / 2 * 0.8
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
probably should be

=ROUND(A1*40%,2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Pete_UKquot; gt; wrote in message oups.com...
gt; Assuming your value is is A1, enter this in B1:
gt;
gt; =A1 / 2 * 0.8
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
Yes, Bob, I thought the OP might understand it more easily written out
in longhand!

Pete