Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|