Olivia creates a personal budget. She enters her current savings account balance in cell D3. In cell A3, she calculates her income for the next three months. And in cell B3 she totals her expenses for the next three months. What formula should she use to calculate the money she will have in her account in three months? = D3+A3-B3 = D3+A3+B3 = D3-A3-B3 = D3A3B3

Question

Jerimiah Kim

Computers & Technology

26 January, 09:24

Olivia creates a personal budget. She enters her current savings account balance in cell D3. In cell A3, she calculates her income for the next three months. And in cell B3 she totals her expenses for the next three months. What formula should she use to calculate the money she will have in her account in three months? = D3+A3-B3 = D3+A3+B3 = D3-A3-B3 = D3A3B3

+1

Answers (1)

Know the Answer?

Tripp David · Answer 1

Answer is:

=D3+A3-B3

These Cell address contain following statement:

D3 = Olivia saving account balance

A3 = Olivia 3 month income

B3 = Olivia 3 month expense

so, Expense are also deducted from income and income is added into saving balance.

In this situation we are use this formula:

=D3+A3-B3