| Home |
| Search |
| Today's Posts |
|
#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 |
Threaded Mode
