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.
Download Our Techie Cheat Sheets
All these keyboard shortcuts have been put together into nicely designed and easy to print cheat sheets which everyone can download for free. After downloading and printing them out, simply fold along the guide lines and glue at the ends to make your own quick reference desktop cheat sheet.
Speed up Excel
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.
This may well impact the entire Microsoft application software industry as they move from XML to JSON data.
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.
We run you through all the steps required
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.
Have you been locked out of your own files?
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.