Important Excel Formulas you should know:
Microsoft excel has a whole lot of formulas included. Excel training is a must for learning Excel because it has so many formula that you never feel satisfied learning them, and you tend to miss out some. You may sign in with the online “excel experts”, as they are the experts in the field of excel and hence they used the name, as “Excel Experts”. The five basic formulas include:
Probability, permutations, and combinations will surely give Goosebumps isn’t it? Suppose you have how many ways can you choose 2 objects out of, say, 50 or 150, or even 2000? Then you will surely get Goosebumps by reading the question which you once have solved it long back may be in 6th grade and now you hardly remember anything of it.
Rounds a supplied number to a specified number of decimal places, and then converts this into text.
c) The Roman:
Arabic integers are the good old numbers that we always end up using. The Roman formula returns the Roman value of an Arabic integer. 543. it’s DXLIII, for what it’s worth. But it’s a useful thing to know, the Roman formula in many other cases and this function would surely going to help you out. It may be of great help if you are in academics.
The Rept formula takes a text string as an input, and repts it out as many times as you like.
Any formula called “Now” deserves to get in simply because it is called “Now”. Have you thought that there could be certain formula like this? Still, it does what you think it would. It simply returns today’s date and time as of just type “now”, and see the magic.
- profile viewed 22 times