How to turn on IMAP on Google’s Gmail service. In order to make your email host connect with IMAP it may need to be configured in the host settings. This isn’t always necessary, in fact usually IMAP is turned on at the email host already. However Gmail requires you to turn on IMAP (or POP) […]
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 […]
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. […]
