SOLVED

round up formula help

Copper Contributor

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 Replies
best response confirmed by marc47555 (Copper Contributor)
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)

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

Accepted Solutions
best response confirmed by marc47555 (Copper Contributor)
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)

View solution in original post