Currency conversion rounding answer

[jmichaeli]

In using the =quotient function to convert Honduran Lemparas to Dollars it entering .00 instead of the actual conversion.

For example I am using =QUOTIENT(F13,18.93) Instead of the actual answer of $445.56 it is entering as $445.00.

I've just started using the 2008 version, and I never had this problem with the old version. I've checked preferences and everything else and can't find a solution. Any ideas?

I appreciate the help.

 

[Bob Greenblatt]

In using the =quotient function to convert Honduran Lemparas to Dollars it
entering .00 instead of the actual conversion.

For example I am using =QUOTIENT(F13,18.93) Instead of the actual answer of
$445.56 it is entering as $445.00.

I've just started using the 2008 version, and I never had this problem with
the old version. I've checked preferences and everything else and can't find a
solution. Any ideas?

I appreciate the help.

Are you absolutely sure? By definition, quotient returns (and has always
returned) the integer portion of the division. Since you formatted the
result as currency, it would, of course, show up as .00 Why not just divide
(=f13/18.93) to get the correct answer?

 

[jmichaeli]

thanks, that did it. i've never done it that way before and it always worked in the previous version as i said in my original post.

it just goes to prove that you learn something new every day and when you stop learning, you're dead!

 

[Bob Greenblatt]

thanks, that did it. i've never done it that way before and it always worked
in the previous version as i said in my original post.

it just goes to prove that you learn something new every day and when you stop
learning, you're dead!

I just can't believe it worked that way in prior versions. Using Quotient is
exactly equivalent to Int(a/b).

 

[JE McGimpsey]

thanks, that did it. i've never done it that way before and it always worked
in the previous version as i said in my original post.

Hmm... From XL04 Help:

QUOTIENT
Returns the integer portion of a division. Use this function when you
want to discard the remainder of a division.