software

hi
I want to round of near to zero. i.e.

If there is a qty * Rate = amt
456*89=40584 than i want to round of like 40580 i want to make last digit
0(zero)
Is any help

Thanks in Advance.

Tiya=ROUND(qty * Rate,-1)

--
tjquot;Tiyaquot; wrote:

gt; hi
gt; I want to round of near to zero. i.e.
gt;
gt; If there is a qty * Rate = amt
gt; 456*89=40584 than i want to round of like 40580 i want to make last digit
gt; 0(zero)
gt; Is any help
gt;
gt; Thanks in Advance.
gt;
gt; Tiya
gt;

=ROUND(value,-1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Tiyaquot; gt; wrote in message
news
gt; hi
gt; I want to round of near to zero. i.e.
gt;
gt; If there is a qty * Rate = amt
gt; 456*89=40584 than i want to round of like 40580 i want to make last digit
gt; 0(zero)
gt; Is any help
gt;
gt; Thanks in Advance.
gt;
gt; Tiya
gt;
Assuming I've understood the question properly

=ROUND(YourFormula,-1)

Will round to multiples of 10
Allow me to hijack your thread slightly.
Is there a way to make Excel NOT round? I'm having trouble with this
end of things.
Please and Thank you
JB--
jbarnett
------------------------------------------------------------------------
jbarnett's Profile: www.excelforum.com/member.php...oamp;userid=31276
View this thread: www.excelforum.com/showthread...hreadid=535501Excel NEVER rounds unless told to, BUT the cell may display a rounded
value if formatted that way - perhaps I've misunderstood the post
though!
Ahh. So it doesn't. I am re-working a document created by someone else,
I figured out the setting though under Format Cells gt; Numbers. But
thanks for your time and input
JB--
jbarnett
------------------------------------------------------------------------
jbarnett's Profile: www.excelforum.com/member.php...oamp;userid=31276
View this thread: www.excelforum.com/showthread...hreadid=535501Excel always rounds if values are held to more dp than are shown
Use the INT function to stop excel rounding automatically - this will cut
off numbers at the dp so be careful with it as sums may not add up !!
--
Rgds, Geoff

quot;A crash reduces
Your expensive computer
To a simple stonequot;quot; wrote:

gt; Excel NEVER rounds unless told to, BUT the cell may display a rounded
gt; value if formatted that way - perhaps I've misunderstood the post
gt; though!
gt;
gt;

Unless you can justify this, no it doesn't!!! It DISPLAYS to those number of
DP, but it doesn't round!
quot;xlboquot; gt; wrote in message
...
gt; Excel always rounds if values are held to more dp than are shown
gt; Use the INT function to stop excel rounding automatically - this will cut
gt; off numbers at the dp so be careful with it as sums may not add up !!
gt; --
gt; Rgds, Geoff
gt;
gt; quot;A crash reduces
gt; Your expensive computer
gt; To a simple stonequot;
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; Excel NEVER rounds unless told to, BUT the cell may display a rounded
gt; gt; value if formatted that way - perhaps I've misunderstood the post
gt; gt; though!
gt; gt;
gt; gt;