what is the difference between round and round up?
ROUNDUP function - always rounds the decimal upward. ROUNDDOWN function - always rounds the decimal downward. ROUND - rounds up if the rounding digit is followed by the digit equal to or greater than 5, otherwise rounds down. As an example, lets round the decimal numbers in column A to 2 decimal places.