CodeSteps

Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...

Microsoft Excel

Microsoft Excel – TIME functions

TIME function in Excel and its related functions are important functions to deal with date-time-related data. As these functions are commonly used with DATE functions, recommended reading an article on DATE functions. TIME function in Excel It returns the time value by taking individual time components (hour, minutes & seconds) as its arguments. Using this […]

Microsoft Excel – DATE functions

DATE function and related functions are important functions to deal with date-related data in Excel. DATE function This function returns the date by taking individual date components (year, month & day) as its arguments. Using DATE function we can form the date-time code using the individual date components. Syntax: DATE(year, month, day) DATE function is […]

Microsoft Excel – How to generate Random numbers?

Microsoft Excel provides RAND and RANDBETWEEN functions to generate Random numbers. Through this Article we are going to discuss about these two functions. Excel random number generator The RAND function This mathematical function is used to generate random numbers between 0 and 1. For example, 0.469059, 0.677718 etc,. Every time this function generates a new […]

Microsoft Excel – Rounding Numbers to the Specified number of digits

We have discussed rounding the numbers using CEILING and FLOOR functions through my previous Article “Microsoft Excel – CEILING and FLOOR functions“. Excel provides another set of functions; provides a similar kind of functionality to round the numbers. Through this article, we are going to discuss these functions. ROUND, ROUNDUP and ROUNDDOWN functions in Excel […]

Microsoft Excel – CEILING and FLOOR functions

As part of Excel functions discussions, we are going to discuss two functions through this Article; which are CEILING and FLOOR functions. The CEILING function This function returns the rounded-up number which is nearest to the specified multiple of significance. It is important to understand that, the return number is based on the specified significance; […]

Scroll to top