here goes another
 

ok i need
A1 number entered = B1 and C1
C1 must end in .00
exp:
A1 / 2 = B1 C1
$10.50 = $5.50 $5.00

$10.80 = $5.80 $5.00

$20.45 $10.45 $10.00

here goes another
 

Put this in C1:
=INT(A1/2)

and put this in B1:
=A1-C1



Joe wrote:

ok i need
A1 number entered = B1 and C1
C1 must end in .00
exp:
A1 / 2 = B1 C1
$10.50 = $5.50 $5.00

$10.80 = $5.80 $5.00

$20.45 $10.45 $10.00

--

Dave Peterson

here goes another
 

In cell B1, enter =A1-C1.
In cell C1, enter =INT(A1/2)

With these formulas, column C will always be a whole number (format with the
desired number of decimal places), and column B will contain the difference
between the values in A and C.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Joe" wrote in message
...
ok i need
A1 number entered = B1 and C1
C1 must end in .00
exp:
A1 / 2 = B1 C1
$10.50 = $5.50 $5.00

$10.80 = $5.80 $5.00

$20.45 $10.45 $10.00

here goes another
 

thank you

"Chip Pearson" wrote:

In cell B1, enter =A1-C1.
In cell C1, enter =INT(A1/2)

With these formulas, column C will always be a whole number (format with the
desired number of decimal places), and column B will contain the difference
between the values in A and C.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Joe" wrote in message
...
ok i need
A1 number entered = B1 and C1
C1 must end in .00
exp:
A1 / 2 = B1 C1
$10.50 = $5.50 $5.00

$10.80 = $5.80 $5.00

$20.45 $10.45 $10.00