I have a formula in a cell that, when calculated, returns a number with 2 decimal places. I want it to round down to the integer and so i have not used the formatting where I can choose to have no decimal places incase it rounds it up.
How do I insert the ROUNDDOWN function.
e.g. my formula is
=E10/((E8-G9)/2)
this may give me a 2 decimal place answer. I only want a whole number,rounded down.
I have put in the ROUNDDOWN function using the insert function buttons but it adds the rounded down figure to the original result, thus doubling the answer. I don't want this, I only want the rounded down figure to appear. Can it be done in one cell?
Bookmarks