Hi there , I have a question about how to write a formula in an Excel spread sheet. I have a list of how many accounts my sales team members have recovered and would like to be able to use a spreadsheet to reflect a bonus structure. For ever 30 accounts they would receive $250.00 and for ever 5 accounts after that $25 (30=250 35=275 40=400 and so on)
Solved by Z. H. in 28 mins