Skip to Main Content
Microsoft Excel Functions & Formulas
book

Microsoft Excel Functions & Formulas

by Bernd Held
September 2006
Beginner to intermediate content levelBeginner to intermediate
397 pages
13h 15m
English
Jones & Bartlett Learning
Content preview from Microsoft Excel Functions & Formulas
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel - Advanced Formulas And Functions

Microsoft Excel - Advanced Formulas And Functions

Guy Vaccaro

Publisher Resources

ISBN: 9781598220117