SOLVED

Simple check register formula problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2672012%22%20slang%3D%22en-US%22%3ESimple%20check%20register%20formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672012%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20set%20up%20a%20simple%20check%20register%20spreadsheet.%26nbsp%3B%20I%20have%20created%20the%20table%20and%20it's%20formatted.%26nbsp%3B%20My%20issue%20comes%20when%20I%20write%20the%20formula%20to%20make%20the%20balance%20a%20'plus'%20or%20'minus'%20depending%20on%20whether%20the%20amount%20is%26nbsp%3Bin%20the%20'debit'%20column%20or%20the%20'credit'%20column.%26nbsp%3B%20Apparently%2C%20I've%20got%20something%20incorrect%20in%20the%202nd%20part%20of%20the%20formula%20because%20it%20works%20until%20it%20gets%20to%20a%20'credit'%20cell%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20an%20example%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(F3%26gt%3B%3D0%2CH2-%5B%40Debit%5D%2CH2%2B%5B%40Credit%5D)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dee642400_0-1629565201975.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304879iDAE2AD785FD91DB6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dee642400_0-1629565201975.png%22%20alt%3D%22Dee642400_0-1629565201975.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20appreciate%20any%20expertise%20on%20my%20not-so-great%20at%20formulas..%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2672012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672049%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20check%20register%20formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672049%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134049%22%20target%3D%22_blank%22%3E%40Dee642400%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSUM(INDEX(%5BBalance%5D%2CROW()-2)%2C-%5B%40Debit%5D%2C%5B%40Credit%5D)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672057%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20check%20register%20formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672057%22%20slang%3D%22en-US%22%3EOK%2C%20error%20msg%20says%20it's%20%22missing%20an%20opening%20or%20closing%20parentheses%22%20I%20added%20a%20second%20%22)%22%20at%20the%20end...%20no%20joy.%20%3F%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672354%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20check%20register%20formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672354%22%20slang%3D%22en-US%22%3EStill%20looking%20for%20a%20hint%20on%20this%20formula...%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to set up a simple check register spreadsheet.  I have created the table and it's formatted.  My issue comes when I write the formula to make the balance a 'plus' or 'minus' depending on whether the amount is in the 'debit' column or the 'credit' column.  Apparently, I've got something incorrect in the 2nd part of the formula because it works until it gets to a 'credit' cell - 

 

Here's an example:  

=IF(F3>=0,H2-[@Debit],H2+[@Credit])

Dee642400_0-1629565201975.png

I appreciate any expertise on my not-so-great at formulas.. 

5 Replies

@Dee642400 

=SUM(INDEX([Balance],ROW()-2),-[@Debit],[@Credit])
OK, error msg says it's "missing an opening or closing parentheses" I added a second ")" at the end... no joy. ???
Still looking for a hint on this formula...
best response confirmed by Dee642400 (New Contributor)
Solution

@Dee642400 No need for an IF. Try it like this?

Screenshot 2021-08-22 at 06.41.37.png

 

 

 

 

It works!! I was making it a big deal when it was really very simple.. Thank you.