IF is one of the functions in the Logical function set of the Formulas tab in Excel. Its greatest use is for running a test and providing a response based on a true or false result. IF is quite a flexible statement and can be used in combination with many others, such as AND, OR, and SUMIF.
We’re in an age of Grab and Go technology for work. From hot-desks to constantly mobile staff, many of us are using laptops more and more to get stuff done. But when your work involves excel, the laptop track pad isn't always the most efficient option. Maybe there’s a faster, better, way to go.
Ground breaking new features in SQL Server 2016 and its impacts on industry.
SQL server 2016 offers a wide range of performance boosting features aimed to the modern workforce. In this post I will be discussing four key features which I find the most interesting.
Outlook is great with rules for many different conditions but often lacking in dealing with attachments. Using VBA for Outlook you can take emails with attachments, rename the files, move based on type, or save the attached files automatically and remove from the email to save on mailbox size.
Ransomware is a piece of malicious software that can encrypt files on your computer, meaning you can no longer access them. Commonly you will just get a popup warning telling you are files are locked and here is how much you need to pay to get them unlocked. This is a Trojan attack which would usually come in the form of an email attachment or file.
Subscribe to our Newsletter for all the latest cheat sheets and resources.