Re: here goes another

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2775F249-6ECF-4AFB-8B2E-50B547AB4EF0@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)
  • Excel 07 - text displays as pound signs
    ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ... any given cell will suddenly appear as all pound signs. ... changed the format to a date. ...
    (microsoft.public.excel.newusers)
  • Re: Date and Time (entering in the format of mm/dd/yyyy and hh:mm:
    ... you can't format the difference to show mm ... Elapsed time is the difference between two times. ... In cell A1, ... On the Home tab, in the Cells group, click Format, and then click ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)