Excel f(x)s = Excel Functions
Standard functions that comes with Excel, plain single functions
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…
Here is a simple formula that uses standard math functions (+ , – , / and *) to calculate the aspect ratio I often need some simple formula like this to get image dimensions Two formulas used here, one in C9: =F9*C3/F3 And another one in cell F7: =C6*F3/C3
I have been there and done that more than once before This time I had a really large cell, more than 3k characters need to be converted into rows, and here is how you can do it. This one uses MID with SEARCH to do that Use one column to get the character number of…
The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump to link to take user to certain area. Of course the “Jump-to” link need other functions, like Match, Indirect and Index Here is a sample of what we can do…
