DATE RECEIPT # JOB # A=ADVANCE D=DEBIT RECEIPT AMT BALANCE
A $100.00 0.00
D $25.00 100.00
Tried =if(d3="A",f3+e3,if(d3="D",f3-e3)) don't work.
DATE RECEIPT # JOB # A=ADVANCE D=DEBIT RECEIPT AMT BALANCE
A $100.00 0.00
D $25.00 100.00
Tried =if(d3="A",f3+e3,if(d3="D",f3-e3)) don't work.
What do you get?
Works for me...
G3 and copied down
![]()
Please Login or Register to view this content.
What should you get?![]()
Please Login or Register to view this content.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks