Forum Discussion
Solved
round up formula help
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)
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)
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)
thank you worked a treat, i had been entering the roundup in the wrong place of the formula.