I have a spreadsheet containing the branch names in Col a and the actual profit figures achieved. Where a branch has not achieved the desired result, I would like to put in the desired profit in Col B. I would like to be able to determine based on the desired net profit in Col B, how many units I would need to sell using an average selling price or average gross profit
I would like to know how I can do this using Excel
I would like to know how I can do this using Excel