Hi all, new to this forum, I have been using Excel as a basic user for many years, but have had no formal training. =sum is about as far as I go!

I run a small taxi business, and I am just about to have two drivers join the business, and I have created a basic spreadsheet that calculates the split in the receipts (they get 40% of the total takings, less tips and extras, I receive 60%, less the cost of fuel). I would like to pay the drivers a guaranteed minimum of £45 per shift, averaged over the shifts that they work each week. For example, if they work three shifts, and take £80, £100 and £150 (for example - total £330), I would like Excel to automatically calculate the amount that they should receive based on a £45 minimum averaged over the week (40% of £330 is £132, but 3 x £45 is £135, so Excel would show their pay as £135 not £132. I hope that that makes sense! I'm thinking the IF command might feature somewhere, but I haven't used this command before.

If this needs to be posted on the commercial side, that's fine, if so please advise how many points I would need to get help. Thanks in advance everybody!

Brian