View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Percentage of a cell

=ROUND(A1*2/3,2))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"geeka" wrote in message
...
Hi

In cell A1 i have £8.99 in cell A2 i want to get 2 thirds of cell a1 into

A2

anyone know the formula

Thanks in advance

Geeka.