Blog & Excel Tips

A common question is why is Excel always 1 day short when subtracting dates? As a result you always need to add 1 day if you want the answer that a human expects.

Excel formulas need a semicolon instead of a comma! How to change back so that you can enter Excel formulas with a comma separating the parts of the formula e.g. =LEFT(A1,2) rather than =LEFT(A1;2)

You build a VLOOKUP and it gives an #N/A (can't find it) but you then use the FIND tool and you find what you were looking for! A common problem in Excel. So why is Vlookup not finding a value that is there.

If you work with lots of data you will come across cases where you need something to happen if a cell is blank, or the opposite i.e. if not blank then calculate in Excel. Perhaps if the Excel cell is blank the formula must result in a zero, or only cells that are not blank should be calculated.

Due to the existence of various software systems, you often need to get numbers to match each others signs. You will therefore need to know the Excel formula to change negative to positive (and vica versa) in spreadsheets.

With the recent announcement of VAT in South Africa changing from 14% to 15% on the 1st April 2018, it is important that you start looking at the new prices you will be charging. To help we have created a simple South Africa VAT Calculator

Your Excel sheet slow yet the spreadsheet is small. You could have inadvertently pasted some objects into your sheet that is processing heavy.

Free download of the South African Tax Spreadsheet Calculator 2018/ 2019 with salary versus dividends optimisation calculation.