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.

=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.

HI,

You must have done this at school
in A2 formula "= A1 x 2/3"
and format a2 as a percentage.
Regards

JY

"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.

geeka Wrote:
Hi

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

anyone know the formula

Thanks in advance

Geeka.
simpliest way
A2
=A1*2/

--
davesexce
-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=53044

Thanks all


"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.