Excel Formula For Counting Text Within A Range Of Cells Favourite Microsoft Excel Functions – Two Functions in MS Excel to Put A Smile on Your Face

You are searching about Excel Formula For Counting Text Within A Range Of Cells, today we will share with you article about Excel Formula For Counting Text Within A Range Of Cells was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel Formula For Counting Text Within A Range Of Cells is useful to you.

Favourite Microsoft Excel Functions – Two Functions in MS Excel to Put A Smile on Your Face

If you’re using Excel, chances are you’re familiar with Excel functions: whether the basics like SUM and AVERAGE or the more complex ones like VLOOKUP and MATCH. However, we bet no one told you about the ROMAN and BAHTTEXT functions.

Roman function in Excel

The ROMAN function converts numbers to Roman numerals. Here are some examples:

=ROMAN(38) returns XXXV1I

=ROMAN(99) returns XCIX

There are some odd things about this function. The first is that it only goes up to 3999 – if you try to find any number above this in Roman numerals, you’ll get an error. Surely the Romans could count higher than this?

The second oddity is that the roman function takes a second argument, which determines the format of the number returned. So, for example, =ROMAN(99,3) returns 1C instead of XCIX.

Perhaps the strangest thing about this function, however, is that it exists in the first place. We like to think that this is provided so that companies can express all their financial statements in Roman numerals. Or maybe it’s that people can talk about the life of a cat or a baker’s XII of IX?

BAHTTEXT function

Wouldn’t it be useful to have a function in Excel that turned numbers into text? For example:

=ThisFunction(38) returns “thirty-eight”.

The good news is actually there is such a function in Excel; The bad news is that it returns text in Thai script. Try typing something like =BAHTTEXT(38) into a cell and press ENTER, and be amazed at the results.

So there you have it: two of our favorite (albeit very useless) functions in Excel!

Video about Excel Formula For Counting Text Within A Range Of Cells

You can see more content about Excel Formula For Counting Text Within A Range Of Cells on our youtube channel: Click Here

Question about Excel Formula For Counting Text Within A Range Of Cells

If you have any questions about Excel Formula For Counting Text Within A Range Of Cells, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Excel Formula For Counting Text Within A Range Of Cells was compiled by me and my team from many sources. If you find the article Excel Formula For Counting Text Within A Range Of Cells helpful to you, please support the team Like or Share!

Rate Articles Excel Formula For Counting Text Within A Range Of Cells

Rate: 4-5 stars
Ratings: 5178
Views: 84528540

Search keywords Excel Formula For Counting Text Within A Range Of Cells

Excel Formula For Counting Text Within A Range Of Cells
way Excel Formula For Counting Text Within A Range Of Cells
tutorial Excel Formula For Counting Text Within A Range Of Cells
Excel Formula For Counting Text Within A Range Of Cells free
#Favourite #Microsoft #Excel #Functions #Functions #Excel #Put #Smile #Face

Source: https://ezinearticles.com/?Favourite-Microsoft-Excel-Functions—Two-Functions-in-MS-Excel-to-Put-A-Smile-on-Your-Face&id=5464079