rounding

[will]

is it possible to round down the result of a
multiplication formula in the same cell and if possible
what would the formula look like?

 

[Gord Dibben]

will

Using the ROUNDDOWN Function from the Analysis ToolPak Add-in

A1 = 24
B1 = 34

=A1*B1 returns 816

=ROUNDDOWN(A1*A2,-1) returns 810

=ROUNDDOWN(A1*A2,-2) returns 800

See Help on ROUNDDOWN for other parameters.

Gord Dibben Excel MVP

 

[Peo Sjoblom]

Gord,

the only round function that is in the ATP is the MROUND.

 

[Gord Dibben]

OOPS!

Thanks for the correction Peo.

Gord

 

[Tushar Mehta]

Gord has already given you a solution. However, could also use the non-
ATP function TRUNC or INT. For more, look up XL help for those
functions.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004

 

[Guest]

If you are always rounding down, you might check FLOOR as well. It's syntax is, in my opinion, easier to work with than ROUNDDOWN

tj