Formula for what you see is what you get
Posted by Somkiat on August 13, 2001 10:10 PM
This is just a simplified question:
I have 3 numbers : 1.5 and 2.5 and 3.5
Then I apply number format to these 3 cells and get : 2 and 3 and 4
What is the formula to get the answer equal to 9 which is 2+3+4? This formula should be able to calculate sum of numbers showed in cells no matter of any format be applied in the future.
I do not need 1.5+2.5+3.5 calculating which is true value in cells.
Please do not use VBA or Precision as Display command. I knew that Sum of Round these cells will do the job already. But round formula will not work in other formats.
Thank you very much,