Category: Excel Functions

The LOWER function converts the upper case texts to lower case in Excel.  =LOWER(text) text: This is the string in which you want to convert …

The UPPER function converts the lower case texts to upper case in Excel. =UPPER(text) text: This is the string in which you want to convert …

In Excel we can use RANDBETWEEN() function to generate the random number in a specified range. Like here in cell A2 we have used RANDBETWEEN() …

The CEILING function in Excel rounds up any specific number to the nearest multiple of any given number. It works similar to the MROUND function …

The FLOOR function in Excel rounds down any specific number to the nearest multiple of any given number. It works similar to the MROUND function …

The MROUND function in excel is used to round a number to it’s nearest specified multiple. =MROUND(number, multiple) Number – This is the number to …