So you’d like to try IMAP? Here’s step-by-step instructions on how to setup Outlook for an IMAP connection. In this series we’ll look at how to setup IMAP. We’ll use Gmail as our host example because it’s free and well supported, however any IMAP host should work (most ISP based mail systems support IMAP). Although […]
Why you might prefer IMAP to get your email into Outlook. What are IMAP and POP? IMAP and POP are methods for retrieving email from an email host like your ISP, Hotmail, Yahoo, and Gmail so you can access it from your desktop through some of the common desktop email applications like Outlook. IMAP is […]
Create the ultimate lookup or decision formula; a User Defined Function using Visual Basic for Applications. by David Goodmanson Following our recent theme of reference, decision and lookup functions, in this article we will go one step further and create the ultimate lookup or decision formula; a User Defined Function (UDF), using Visual Basic for […]
Excel alternatives to nested IF’s from our readers. After David Goodmanson’s features on IF and nested IF’s we’ve received many messages from readers suggesting another alternative – CHOOSE() and here even more possiblities. Tony D writes: “ Small snippet for your “IF” library next time. I’m sure there will be hundreds of better ideas, but you […]
A look at nested IF statements and alternatives that are easier to make and understand later. by David Goodmanson In my last article I looked at a simple Excel IF statement plus their useful cousins CountIf and SumIF. I also touched on the nested IF statement, where there are many IF functions in one cell. […]
