Forum Discussion
Solved
Rounding issue with Excel
I have Microsoft 365 and I have a problem with calcuating from one column to another. If I do a calculation such as =$1008.00(I19)*.434*103% and it equals $450.60 ea. Then in my summary column whic...
- formatting of a cell is only how it is displayed and will not round off numbers. if you want to force it to 2 decimal places you have to add ROUND(the-value, 2) so in your example above (which doesn't make sense to me but: =ROUND($1008.00(I19)*.434*103% , 2) and this will for the result to actually be rounded to the cent not just viewed that way. Another option is in Excel options to force excel to round off to displayed precision but I don't recommend that way.
formatting of a cell is only how it is displayed and will not round off numbers. if you want to force it to 2 decimal places you have to add ROUND(the-value, 2) so in your example above (which doesn't make sense to me but: =ROUND($1008.00(I19)*.434*103% , 2) and this will for the result to actually be rounded to the cent not just viewed that way. Another option is in Excel options to force excel to round off to displayed precision but I don't recommend that way.
Thank you so much - that works. I guess I did write it in a somewhat confusing way. This has been frustrating me for YEARS!!!!