Another question concerning IF statements
 

Ok I thought of another question to ask about the same project I am working
on :)

I am creating a worksheet that has information about accounts from day to
day. In the start of the worksheet I have the opening account information for
Day 1 and in the second column is the information from Day 2. The third
column has a formula that shows the change in balances from Day 1 to Day 2.
The formula for the change in accounts is: =IF(E2<0,(D2-E2),""). I am using
the formula so if there is not a balance in one account, it will just remain
blank so it will be easy to identify.

However, if the balance in one account is -800 and then it increases to 0 in
Day 2, how can I alter the formula to display the correct balance while still
being able to use that formula for the other 4000+ accounts?

Jessica,
Your current formula should show the appropriate change in balances.
If
day 1= -800
day 2= 0
and day 2 - day 1 = change in balance

(0) - (-800) = 800
Positive 800 would be the correct change in balance.

"Jessica" wrote:

Ok I thought of another question to ask about the same project I am working
on :)

I am creating a worksheet that has information about accounts from day to
day. In the start of the worksheet I have the opening account information for
Day 1 and in the second column is the information from Day 2. The third
column has a formula that shows the change in balances from Day 1 to Day 2.
The formula for the change in accounts is: =IF(E2<0,(D2-E2),""). I am using
the formula so if there is not a balance in one account, it will just remain
blank so it will be easy to identify.

However, if the balance in one account is -800 and then it increases to 0 in
Day 2, how can I alter the formula to display the correct balance while still
being able to use that formula for the other 4000+ accounts?