Tag Archives: ROUNDDOWN

Using financials in Mail Merges

Imagine you have a financial figure that you want to use in a mail merge (a salary, bonus, house prices etc.) If you use them as they stand, they'll likely look rubbish. They won't show the currency and there won't … Continue reading →

The ROUND function works both sides of the decimal place

Most people who have used the ROUND function will have used it to the right of the decimal place. =ROUND(A1,2) This will round cell A1 to two decimal places. So 3.1415 will become 3.14. And 2.718 will become 2.72. But … Continue reading →

Distances between places as the crow flies

Challenge: I have two the latitude and longitude of two places. I want to know the distance between them, as the crow flies. This took a lot of trial and error, made more tricky by having to also accommodate two … Continue reading →