## Personal Mileage

Hello, Please help i am currently trying to figure out the best formula to use when calculating cumulative mileage claims, for example if Mr A has driven 9500 …

Hello, Please help i am currently trying to figure out the best formula to use when calculating cumulative mileage claims, for example if Mr A has driven 9500 …

Hi I was hoping you could guide me on how I can calculate my commission based on more than 3 factors. i.e. our company uses 3 different lendcare services (we …

I want to automatically reduce a number each time I add a new amount to a list to enable me to see whenever I have spent an amount I will know how much I have …

Hello, I hope you can help me with the following problem I am encountering. I have around 2000 rows with a set of 8 different numbers in each row. For …

Microsoft Excel comes with a great function, AVERAGE, that will quickly average a range of cells that you specify. When you average numbers what you are doing …

How to compute the total cost and referring to the rate as an absolute cell

In a previous post I talked about SUMIF – summing cells based on a condition, in this post I will talk about SUMIF based on not matching a criteria. So …

Summing the largest numbers in a list can easily be completed by combing the Excel SUM and Excel LARGE functions together into one formula. Doing this will …

In a previous post I talked about how to SUM cells using Excel’s SUM function. This is a great way to sum cells quickly, but did you also know you can …

Before Excel 2007 the maximum number of rows per worksheet was 65000! And if you had numbers in just a thousand of those, and needed to a total of all the …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.