I have several formulas in my excel sheet. For example:
A1 B1 C1
23,821 x 129.20 = 3,077,673.2 (but i wanted this cell rounded to no decimals, so its really 3,077,673)
A2 B2 C2
4,384 x 93.29 = 408,983.36 (again rounded to no decimals, to be 408,983)
Now I need the product of C1 (3,077,673) and C2 (408,983) and its giving me 3,486,657 - im guessing because its still factoring the decimals and then rounding up?
How can I get it to add only the true numbers I have so it says 3,486,656?
Bookmarks