rounding

W

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?
 
G

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
 
T

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
 
T

tjtjjtjt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Autonumber field in Excel that behaves the same as Access 0
Organizing a group of notebooks 0
MROUND Help 1
ROUND UP COLUMN TOTAL OFF 1
vlookup and rounding 4
adding a forumla to cells with formula in them already 1
rounding a number up to a certain ending digit 6

Top