Hi . . . first, thanks for this forum and thanks for anyone who can help me solve this problem.
1. I am using MS Excel 2013.
2. I have a calculated cell. Example a formula that looks like: (C12/C6). Using example numbers: (= 0.185/76.2).
3. This gives the answer: .002427822
4. I know that I can show as many decimal places as I want, but when I reduce the number of decimals, I end up with .00243. But what I want to do is the following:
* I do not want this number to be rounded off to .00243.
* I want the number in this cell to have the value of .00242 for use in future calculations. In other words, I do not want the "7" to have an impact on the "2" by rounding it up to "3".
I have TRUNC but it generates an error for me when I use it before a formula. I have tried ROUNDDOWN but that does not seem to work. I may be using it improperly.
Any suggestions will be greatly appreciated.
Best wishes, KC
Bookmarks