Get rid of rounding error

Hello, got a problem with a spreadsheet at work.

For an calculation I need to calculate the average Full time equivalent of staff.

Sheet is set up like this this: Column A: Person ID Column B: duration of period in days Column C: full-time equivalent Column D: weighted full-time equivalent for period Column E: average Full time equivalent over year

Column A to C are preset base data. Formulas are in column D and E Calculation is basically done, broken down the formula is:

In column D: =ROUND([duration days]/365×[Full time eqivalent for period];4)

In column E it is: =SUMIF([Person ID]; [Person ID]; [Weighted for period])

But because if the rounding it doesn't add up to 1, it gies to 0,9999, even if the full year average is 1.

Any ideas, how to fix that? (Other than IF(0,9999; 1; do the math) 😂)

Was thinking about something like " if all Full time equivalent for period (column C) for one person ID (column A) are 1,0000, then make the average over year 1,0000, if not make the calculation based on my current formula for column E" but I can't get the operators right for that.

Thanks in advance fir any help😂

Edit: moving rounding to column E instead of D did the trick. Sometimes its the obvious stuff xD

Thanks to all