B5>0: This is the other ‘if’ statement that asks whether the deposit field is filled out.C4-A5: This is what happens if there’s a value in A5 we’ll take the balance minus the value in A5.A5>0: This is the first if statement that says if A5 is greater than 0 (i.e., if there’s a value there at all), then do the following….We want one formula to run if the expense is filled out (this would be subtraction like shown above) and a different one (addition) if the deposit if entered. The ifs part is simply saying that we’re wanting to match more than one “if” because we don’t know if the expense or the deposit will be filled out.
