Forum Discussion
Help with Excel Calculation
AlisonAMK Your "problem" is round off errors or in this case carry through or higher precision. If you want to force the round off at various points use ROUND( N , X) where N is the calculated value and then X is number for digits of precision to keep before rounding off. So in your case, by changing F6 to:
=ROUND(D6*5,2)and changing E8 to:
=ROUND(5*D8,0)the answer now displays 96.30
That said I really don't understand why you are doing what you are doing per se. For example, what is the justification for wanting to force these round off cuts? Especially when you are dividing by 365.2425 in the first place to get so many sig-digits.
As for making the calculations easier? It all depends on what values you need (either to see or for other calcs elsewhere). You CAN create NAMEs to define particular values and then your calculations can look like: = Annual/TotalDays instead of =C6/365.2425
mtarler Thank you for your reply.
As you can see, i have no clue about excel - the reason for the calculation is to do with payroll. The software provider has shown their version in a demo which was what i was trying to put into excel, hoping that all i needed was the salary and hours to input and the rest would sort itself.
I'm not sure how to do your suggestion, but will have a go.
Many thanks again for your help.