I am using this formula =I13*(1.02264)*(G13)/(3.6) which gives the result 2333.89
How do I include `rounddown` so that the result reads 2333
Or is there some other method of doing this.
Thank you
I am using this formula =I13*(1.02264)*(G13)/(3.6) which gives the result 2333.89
How do I include `rounddown` so that the result reads 2333
Or is there some other method of doing this.
Thank you
I'm not sure if this is the smartest way, but in the next column you can use =FLOOR(A1,1) and just hide the other column?
3 ways.
=INT(I13*(1.02264)*(G13)/(3.6))
=TRUNC(I13*(1.02264)*(G13)/(3.6))
=ROUNDDOWN(I13*(1.02264)*(G13)/(3.6),0)
I believe Excel has had ROUNDDOWN since Excel 2010. You don't show your Excel version. However, the 1st 2 formulas work at least back to Excel 2000. INT and TRUNC work differently for negative values: INT(-1.8) -> -2, TRUNC(-1.8) -> -1. That is, INT always returns the next smaller integer, TRUNC returns the integer with smaller absolute value.
hringrv,
Thank you, when attempting to use COUNTDOWN I was missing the ,0)
at the end of the formula.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks