Question

Allen needs to calculate how much his investment has increased over the past year. He enters the original amount in cell B3 and the new amount in cell B4. He typed in the formula: =B3-B4. He estimated his answer to be 500 and the answer is not close. He should _____.

add the values in B3 and B4
ignore his estimation
multiply the values in B3 by B4
change the formula to =B4-B3

Answer 1

You need to change the formula to =B4-B3 this will calculate the right value.

Step-by-step explanation:

The value stored in B3 is the original amount and new increased amount is stored in B4 which is larger than B3 value so the formula need to change to subtract large value from small to get the value how much his investment is increased.

Difference = Increased investment - Previous Investment

Following are attached images of excel that will make the concept more clearer: