Scribd
Upload
212 views1 page

Rounding Formulas in Excel

The document discusses various Excel formulas for rounding numbers including ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, EVEN, ODD, and FIXED. It also provides a formula for searching a string in a cell and returning a particular keyword.

Uploaded by

sjk_akol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
212 views1 page

Rounding Formulas in Excel

The document discusses various Excel formulas for rounding numbers including ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, EVEN, ODD, and FIXED. It also provides a formula for searching a string in a cell and returning a particular keyword.

Uploaded by

sjk_akol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

MS Excel Formulae

1. Rounding Formulas in Excel


Before learning the tips, first lets understand various rounding formulas &
what they do. Look at this:
Formula

What it does?

ROUND

Rounds a number to specified decimal points (or


multiples of 10)

ROUNDUP

Rounds up a number

ROUNDDOWN

Rounds down a number

MROUND

Rounds to nearest multiple of specified number

INT

Rounds down to nearest integer

TRUNC

Gives you only integer portion

CEILING

Rounds up a number to nearest multiple of 1,10,100

FLOOR

Rounds down a number to nearest multiple of


1,10,100

EVEN

Gives next even number

ODD

Gives next odd number

FIXED

Rounds and converts to text format (with commas if

you want)
http://chandoo.org/wp/2012/09/28/round-numbers-excel-formulas/

2. Search a String in Cell and Return a Particular Key


Word
2.1. Formula:
=IF (ISNUMBER (SEARCH (-C-, C15),PRINT, RECHECK))

You might also like