here goes another

J

Joe

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
 
C

Chip Pearson

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)
 
J

Joe

thank you

Chip Pearson said:
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)
Click to expand...
 
Top