Need help Rounding down

Ok, here is my situation.

I have a worksheet (Sheet1) that gets information from other sheets (1)

So in cell D7 I have the function ='1'!K33

K33 is from the Sheet labeled (1) obviously. Now the problem I am having is if the number 20.6, it automatically rounds up to 21. I need to number to round down to 20 regardless if its 20.1, or 20.9.

Since I already have a formula in D7, how do I still get the information from the other sheet but have the number round down for me. Is it possible?

Thanks in advanced

You can use the function ROUNDDOWN which can have formula which generate a result nested within itsself

for example

A1 = 20
B1 = 0.9
C1 = "=Sum(A1:B1)" which would give 20.9

you could nest the formula in C1 into rounddown

A1 = 20
B1 = 0.9
C1 = "=rounddown(sum(A1:B1),0)" this would result in the cell value being rounded down to 20

you can even round down the refrenced value as below

=ROUNDOWN('1'!K33,0)

this will rounddown the refrenced value, but not the value in '1'!K33


--- How the Formula Works ---

=ROUNDDOWN("THIS IS THE NUMBER TO ROUND DOWN, IT CAN EVEN BE ANOTHER FORMULA", "THIS IS HOW MANY NUMBERS TO ROUND DOWN TO")

i hope this has been of some help to you?

Teshi

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.


Moved to Functions Forum

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save