studometry
New Member
- Joined
- Nov 28, 2014
- Messages
- 1
Hello Guys maybe you can help me out am using Round(....,2) function.... Lets say Tom gets a salary of 1333.33 every 2 weeks, 8% of that needs to be taken out every time he gets paid so thats 106.67 each time.... in one sheet i have 106.67 listed two times and when its added i get 213.34. In a next spreadsheet only the total amount for the month gets used which is 2666.66 and 8% is calculated from that which is 213.33.... that is a cent different, is there another formular i can use? that would make this a more accurate number? rounding it to 3 places works but it then throws off my other values in the sheet, please help