|
Posted to microsoft.public.excel.misc
|
|
|
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
|