If you have 100 in cell A1, the formula { = A1/10 } in the cell where you
want the 10% to be shown will cause 10 to be displayed.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Terry" wrote in message
...
i need a formula that will show me 10% of a given amount. I have a table
that has a price of an item. the cell next to it will show the value of
10%
of this price. I have tried every formula i can think of but get the
wrong
answer or a syntax error every time