Hello, id like the below to have a round up to the nearest 4 in the result is this possible please?
=IFERROR(VLOOKUP($C4,'Av Orders'!$B$4:$BC$96,MATCH(ET$1,'Av Orders'!$B$2:$BC$2,0),FALSE)*VLOOKUP($C4,'Splits Av'!$C$4:$PD$97,MATCH(ET$3,'Splits Av'!$C$3:$PD$3,0),FALSE),"")
=IFERROR(VLOOKUP($C4,'Av Orders'!$B$4:$BC$96,MATCH(ET$1,'Av Orders'!$B$2:$BC$2,0),FALSE)*VLOOKUP($C4,'Splits Av'!$C$4:$PD$97,MATCH(ET$3,'Splits Av'!$C$3:$PD$3,0),FALSE),"")