round up formula help

[marc47555]

Hi,

id like to round this formula up so the end result will be summed to the nearest 4

IFERROR((SUM(D4:G4)-(SUM(MAX(D4:G4)+MIN(D4:G4))))/(COUNT(D4:G4)-2),"")*(1+'%'!J5)

[#2 · Accepted solution]

@marc47555 See if MROUND does what you require.

=MROUND(IFERROR((SUM(D4:G4)-(SUM(MAX(D4:G4)+MIN(D4:G4))))/(COUNT(D4:G4)-2),"")*(1+'%'!J5),4)

[#3]

thank you worked a treat, i had been entering the roundup in the wrong place of the formula.