Multiply the cell by 0.03

A1 = 100

=A1*0.03


--
Biff
Microsoft Excel MVP


"Michael Higgins" wrote in message
.uk...
Hi,

I have had one of those days, i would like to know how to simply get a 3
percent figure from a box with a add sum formula and place it in a box
else where on the sheet i bet its something that can be done whilst
sleeping but its getting me big time.

Michael