In cell D12, enter a formula to calculate the difference between the Actual and Budget. Copy the formula to the range D13:D19. Delete the formula in cell D15. If the Actual expense is more than the Budget expense, the result is positive. If the Actual expense is less than the Budget expenses, the result is negative, indicating under budget.

Question

Anastasia

Business

13 May, 06:47

In cell D12, enter a formula to calculate the difference between the Actual and Budget. Copy the formula to the range D13:D19. Delete the formula in cell D15. If the Actual expense is more than the Budget expense, the result is positive. If the Actual expense is less than the Budget expenses, the result is negative, indicating under budget.

+1

Answers (1)

Know the Answer?

Micheal Valentine · Answer 1

I don't really have enough information to answer this, but you would set up a formula that would look like:

= Actual (whatever cell reference this number is in) - Budget (whatever cell reference this number is in)

You would then copy this formula to the rest of the cells mentioned in the prompt.