Excel formula not returning expected results
Out of curiosity, I manually checked the formula in the first screenshot below and got a different result. (As you see, the formula returned $49,515.63, while my manual check returned $49,015.63, as you see in the last screenshot below. A $500 difference.
Can anyone explain what’s going on? I’d appreciate any insight!
To check the formula, I went to the List of Transactions tab and did the following:
Column G: Set the filter to ≥ 0 (per screenshot below) Column J: Set the filter to show only “R” (screenshot below)
Column G: Noted the total (screenshot below)
Checked the line numbers to ensure that all of them are ≥3 and ≤ 316, which they are
Out of curiosity, I manually checked the formula in the first screenshot below and got a different result. (As you see, the formula returned $49,515.63, while my manual check returned $49,015.63, as you see in the last screenshot below. A $500 difference. Can anyone explain what’s going on? I’d appreciate any insight! To check the formula, I went to the List of Transactions tab and did the following:Column G: Set the filter to ≥ 0 (per screenshot below) Column J: Set the filter to show only “R” (screenshot below)Column G: Noted the total (screenshot below) Checked the line numbers to ensure that all of them are ≥3 and ≤ 316, which they are Read More