Hi,
I'm wondering if anyone would be able to help please.
If I wanted to format a cell that sums up other cells to automatically have zero's after the decimal place i.e. .00, how would I make this possible?
Eg/ =SUM(A2+A3) = £132.34 (A10) how would I make that round down to £132.00
Another example would be if the decimal value is above .50, how would I make this round up to .00 eg/ =SUM(A2+A3) = £132.64 (A10) to then read £133.00
I am currently using Excel 2016.
If any additional information is required please let me know.
Thanks so much,
Jess
Bookmarks