![]() TRUE,””: This is a placeholder that will mark the cell with nothing unless there’s something to calculate.C4+B5: If there’s a deposit, then add it to the balance to calculate the new balance. ![]() 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |