Convert Numbers into English text and the final version of the Excel function to convert numeric values to Arabic text, (as 500 to خمسمائة). It will also enables you to add the unit you want. this was really hard in Arabic language. UDF means User-Defined-Function, which means you need to enable macros Use the English […]
This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress bar in pure functions, using the formula: =REPT( CHAR( 8),INT( D2/10))&REPT( CHAR( 7),INT( D3/10)-INT( D2/10))
This will help you do a dynamic name to use on a drop down, a Form Listbox or Form Combobox. The screenshot almost says it all. You need 4 steps: 1- Create the name for a column in your Excel file, go to Names > Define in Excel2003 or earlier, or go to Formulas > […]
Using a single function can make a graphical view to your number Function is REPT along with IF and INT to show that number in graphical view, formula used here is: =IF(B4<5,REPT(“|”,B4),REPT(REPT(“|”,5)&”-“,INT(B4/5))&REPT(“|”,B4-INT(B4/5)*5))
Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text, helpful when you have strings without spaces and want to convert them. It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request. […]
This is the answer to an old question: Here is the story behind it: I had a client who calls me every now and then asking the same question: ” Can you please remind me of how I would use an array formula? you know, enter multiple conditions into one SUM function? ” Then I […]
