Adding the ROUNDUP function to an existing nested formula containing IFERROR & AVERAGEIF

[znxm0i]

Hi all,

I have the following formula and I need to add the ROUNDUP function to it so that it rounds up anything greater than 5 after the decimal point. Where do I add the ROUNDUP function to this formula please.

=IFERROR(AVERAGEIF('Data Raw'!$T$4:$T$136,"Commercial",'Data Raw'!$U$4:$U$136),0)

Thank you.

 

[Joe4]

Are you sure that you really need ROUNDUP and not just ROUND, i.e.

[COLOR=#333333]=IFERROR(ROUND(AVERAGEIF('Data Raw'!$T$4:$T$136,"Commercial",'Data Raw'!$U$4:$U$136),0),0)[/COLOR]

 

[znxm0i]

Are you sure that you really need ROUNDUP and not just ROUND, i.e.

[COLOR=#333333]=IFERROR(ROUND(AVERAGEIF('Data Raw'!$T$4:$T$136,"Commercial",'Data Raw'!$U$4:$U$136),0),0)[/COLOR]

Thank you for providing such a quick response.

Well the way I read the difference between ROUND and ROUNDUP is that I should use ROUNDUP if I wanted to roundup to the next nearest number if the value after the decimal points was greater than 5; and use ROUNDDOWN if was less than 5

If I just use the plain ROUND function will it round up and round down as applicable?

Also, one of my values is 128.30 but when I apply the revised formula to the cell it changes it to 128.00 do I have to use the Excel formatting function for decimals in conjunction with the ROUND function?

 

[Joe4]

ROUND rounds to the nearest number (so 5 and greater rounds up, 4 and less rounds down).
ROUNDUP ALWAYS rounds up. So any decimal will round up to the next highest number.
ROUNDDOWN does the opposite (always rounds down to the next lowest number).
Try playing around with each, and you will see what they do.

The formulas themselves do not determine the number of decimal places to show. That is handled by how the cell is formatted.