Rounding to nearest $

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

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Sarah" wrote in message
...
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 Harald,

if you give my your credit card number I will transfer one cent to it?
bg

--

Regards,

Peo Sjoblom

"Harald Staff" wrote in message
...
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 :-)

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Sarah" wrote in message
...
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

"Peo Sjoblom" skrev i melding
...
Hi Harald,

if you give my your credit card number I will transfer one cent to it?
bg

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