Rounding to nearest $

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

How do we change the EVEN function to get the actual
number. Currently it is rounding down to the closest
dollar figure.
Example:
11.67 * 12=$140.04. Using the excel formula the answer is
$140.00.

The worksheet seems to have a hidden formula behind the
cell.

Thanks,
Sarah
 
Hi Sarah

Excel is not wysiwyg. What is displayed as 11.67 is probably really 11.6666666666666 .
Which makes her answer correct and not rounded at all. As in
10 / 3 = 3.33
3.33 * 3 = 9.99
the missing cent is transferred to my credit card -as always :-)
 
Hi Harald,

if you give my your credit card number I will transfer one cent to it?
<bg>
 
Peo Sjoblom said:
Hi Harald,

if you give my your credit card number I will transfer one cent to it?
<bg>
Click to expand...

Thanks Peo, I'll send you the card as soon as I get it back from the Central
Bank of Nigeria <bg>

Best wishes Harald
 
Back
Top