Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » Formulas (RSS)

Browse by Tags

  • Formula Tips

    Al sent me a formula to revise. Before: =IF($B11<>0,IF(OR(ISNUMBER(FIND("-",J11))=TRUE,ISNUMBER(FIND(" ",J11))=TRUE,ISNUMBER(FIND("_",J11))=TRUE), IF(ISNUMBER(FIND("-",J11))=TRUE,TRIM(SUBSTITUTE(J11,"-","")),IF(ISNUMBER(FIND(" ",J11))=TRUE,TRIM(SUBSTITUTE(J11,"  ","")),IF(ISNUMBER(FIND("_",J11))=TRUE,TRIM(SUBSTITUTE(J11,"_","")),TRIM(J11)))),TRIM(J11)),"") After: =IF($B1<>0...

  • Cash Advances on Credit Cards

    I had the unfortunate opportunity to learn how cash advances on credit cards work. The particular card I saw was from Capital One, but I think they all work the same. There are three important things to know about cash advances: The interest rate is huge - usually in the mid-20% neighborhood Interest starts on [...] Read More...
    Filed under:

  • Multiple Substitute Formula

    MaryAnn asks an interesting question. In column A there is text that may or may not contain the name of a US state. In column B there is a list of US states. In column C, we want the column A text without the state names. I think this would be a pretty [...] Read More...
    Filed under: ,

  • Formula Tokenizer

    A few years ago, I wrote a Formula Formatter add-in to present a long formula for easier reading. It does it through a process called Tokenizing, which is basically a process of putting the components of a formula into labelled boxes. That add-in was compatible with Excel 2003 formulas, but Excel 2007 brought us extra formulas [...] Read More...

  • Golf Scores

    A couple of my golf buddies and I were debating the handicaps of a course we regularly play. Each hole of a course is handicapped 1 through 18 with 1 being the hardest hole and 18 the easiest. Handicaps are used to allow golfers of differing abilities to complete equitably. Because my [...] Read More...
    Filed under: ,

  • External Links

    Ron sez: What happens often is that one person will have one of these spreadsheets open and the other spreadsheets linked to the subject spreadsheet closed and decide to insert a column that throws off the references of the closed linked spreadsheets. If the person knew which spreadsheets were linked to it, the person could open [...] Read More...
    Filed under: ,

  • Range within a Range

    I recieved this email from my pal Simon: “One of the problems in many of the spreadsheets and potential spreadsheets I come across is the need to automatically adjust to changing areas of external data. It seems at first glance that, to refer to a single column in a block of external data, the intersection operator [...] Read More...
    Filed under:

  • Variable Hyperlinks

    Excel provides an easy way to create a table of hyperlinks and even save the workbook as a web page. The built-in method for creating a hyperlink is Insert > Hyperlink (Ctrl+K). The problem with this method is mass changes, like renaming your server. Editing each one (if you have a lot) [...] Read More...

  • Steady vs. Volatile

    I read my retirement account statement today. It wasn’t pretty. A lot of low, single digit returns lately. I know people who complain when the market tanks, but I’m not one of them. When it comes to my retirement, I want the market to keep going down until I’m 59 1/2, [...] Read More...
    Filed under:

  • ExcelRefTool; A New Formula Auditing Tool

    Hi, A while ago I requested beta testers for a new utility, now called "ExcelRefTool". Thanks to my beta testers, the tool is now mature enough to be exposed to the general public. Have a look here, download the demo if you like and give it a spin. And thanks again, to everyone who took the trouble of beta [...]
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.