
remainder, extracting from division, 170
REPLACE function, 71
replacing characters, 71-72
REPT function, using to repeat
character, 82, 83
RIGHT function,
extracting date parts, 99, 100
separating data, 353-354
separating text string of numbers, 58
ROMAN function, 181
converting Arabic numerals to
Roman numerals, 181
ROUND function, 156
rounding numbers, 156
rounding time values, 159, 160
ROUNDDOWN function, 157
rounding numbers down, 157
ROUNDUP function, 158
rounding numbers up, 158
row,
determining last filled, 139
filtering every other, 236
finding last number in, 231, 279
finding smallest number in, 127
shading every third, 248
summing in a dynamic list, 291
ROW ...