JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 593
- Office Version
- 365
- Platform
- Windows
I am doing a sum formula and need some help on rounding.
One of my examples: 77.8 (shows as 78) minus 82.5 = -4.7
How do I get it to show a total of 4.5? Because in reality 78 - 82.5 = -4.5
Another one: 109.1 (shows as 109) minus 95.5 = 13.6 but I really need it to say 13.5
Any help appreciated
James
One of my examples: 77.8 (shows as 78) minus 82.5 = -4.7
How do I get it to show a total of 4.5? Because in reality 78 - 82.5 = -4.5
Another one: 109.1 (shows as 109) minus 95.5 = 13.6 but I really need it to say 13.5
Any help appreciated
James