'of' percentage with calculation (attempt 2)
 

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

'of' percentage with calculation (attempt 2)
 

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

=A1 / 2 * 0.8

Hope this helps.

Pete

'of' percentage with calculation (attempt 2)
 

=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

'of' percentage with calculation (attempt 2)
 

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

'of' percentage with calculation (attempt 2)
 

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

Pete