Question about decimal places

[chrisgoulden]

I have a worksheet function that gives me a result in a dollar valu
with 2 decimals, let's say it produces the following value: $11.85.
Now, the actual value is more like this $11.85983733333 because it's
result of a much more complex formula, but of course I have it rounde
off to 2 decimal places. I have another formula that takes the abov
number and multiplies it by a number of hours, say 5000, and I get
dollar value, BUT I want the second formula to grab the $11.85 in th
first formula and use that, but instead it grabs the long un-rounde
version. How do I get it to grab the result that I want? Am I makin
sense? I can explain myself further if necessary. Thanks

 

[Arvi Laanemets]

Hi


"chrisgoulden" <[email protected]>
wrote in message

I have a worksheet function that gives me a result in a dollar value
with 2 decimals, let's say it produces the following value: $11.85.
Now, the actual value is more like this $11.85983733333 because it's a
result of a much more complex formula, but of course I have it rounded
off to 2 decimal places. I have another formula that takes the above

How you did it? Rounded using ROUND(), set 'Precision as displayed' from
Tools>Options>Calculations to be checked for a while, or simply formatted
cell as number with 2 decimals. When latter, then formatting affects only
the way, the cell value is displayed, not the value itself.


Arvi Laanemets

 

[Pete]

In the cell that produces $11.85983733333 by some formula, you should
modify this to:

=ROUND(your_formula,2),

although I would have thought this would produce $11.86 - if you really
want $11.85, use:

=ROUNDDOWN(your_formula,2), or
=INT(your_formula*100)/100

Hope this helps.

Pete

 

[chrisgoulden]

Pete.........Thank you.........this works great!!!!!!! My boss will be
so happy!!!!!!!!!!!!!!!

 

[Pete]

Hi Chris,

thanks for feeding back, glad it worked for you.

Pete