How can I solve the SE formula when I don't
there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
Can you solve this problem?
How can I solve the SE formula when I don't
there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
Can you solve this problem?
This ?
Formula:Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
John
But in this case, the part of the If in columns C and D being zero fails.
Show expected outcome if C=0 and/or D=0
Last edited by JohnTopley; 04-26-2024 at 03:27 PM.
It's just that one column is debit and the other credit, in which case it would be one or the other.
You have not answered my request in post #4 so I cannot help.
For the future, always show expected results to preclude so much guessing.Please Login or Register to view this content.
Ben Van Johnson
I don't know if I've understood correctly, but if the columns have zero in column H, the value must be repeated.
In your example just remove the IF and try only and copy down:Formula:Please Login or Register to view this content.
But what I wanted most was that in the debit and credit columns with zero balance, the calculation formula would only be valid with values in the columns
I don't exactly understand what you want.
Please show the expected results of the formula in your sheet,
This:
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or this:
Formula:Please Login or Register to view this content.
All the replies result in the same outcome so, if this is incorrect, you need to post a file (as requested more tthan once) with your manually-calculated results
@JT: post #13 has a different outcome.
In the spreadsheet I tried to show you what I need
Thank you very much for your attention
H3, copied down, seems to give you what you want.
Formula:Please Login or Register to view this content.
Bear in mind, you can have a value in a cell, or a formula, but you cannot have both. If you overwrite a formula with a fixed value, you cannot copy it down.
Why wouldn't you want a formula on days without transactions?
If you try in cell K2 =H2 and
if you try this formula in K3 and copy down =K2+C3-D3,
you will get exactly the results you want.
Even on days without transactions.
Why make it difficult when it can be easy?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks