H
Horst
Can someone give me the right formula plase
IF(F14:G14=VALUE,SUM(H13+F14-G14),0)
IF(F14:G14=VALUE,SUM(H13+F14-G14),0)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
=IF(F14+G14=123,H13+F14-G14,0) where <value>=123
T
Toppers
...... or do you mean...
=if(OR(F14=value,G14=Value),H3+F13-G14),0)
i.e if F14 OR G14 Value?
If both F14 AND G14 = Value then change OR to AND
=if(AND(F14=value,G14=Value),H3+F13-G14),0)
HTH
=if(OR(F14=value,G14=Value),H3+F13-G14),0)
i.e if F14 OR G14 Value?
If both F14 AND G14 = Value then change OR to AND
=if(AND(F14=value,G14=Value),H3+F13-G14),0)
HTH
C
Carim
Hi Horst,
Difficult to guess ...
could be
=IF(F14=G14,H13+F14-G14,0)
HTH
Carim
Difficult to guess ...
could be
=IF(F14=G14,H13+F14-G14,0)
HTH
Carim
H
Horst
That didn't work. I'm trying to create a running ledger but I don't want it
to automaticaly to configure unless the next entry has been posted.
to automaticaly to configure unless the next entry has been posted.
T
Toppers
Please explain what you want to happen .. just giving a formula isn't
sufficient.
sufficient.
H
Horst
I like to start with a balance in the row above. If I have a debit or credit
on the next row, I would like to calculate the balance cell on that row to
give me the new total. If there is no entry, I would like the balance cell on
that row to show 0 or stay blank. This should be like a regular check
register.
on the next row, I would like to calculate the balance cell on that row to
give me the new total. If there is no entry, I would like the balance cell on
that row to show 0 or stay blank. This should be like a regular check
register.
R
Ragdyer
Try this:
=IF(AND(F14,G14),H13+F14-G14,0)
And copy down as needed.
=IF(AND(F14,G14),H13+F14-G14,0)
And copy down as needed.
C
Carim
Hi,
If I may Toppers is right ... a clear explanation would help ...
=if(AND(F14<>0,G14<>0),H3+F13-G14),0)
This formula would perform the calculation only if both F14 and G14 are
different from 0 ...
HTH
Cheers
Carim
If I may Toppers is right ... a clear explanation would help ...
=if(AND(F14<>0,G14<>0),H3+F13-G14),0)
This formula would perform the calculation only if both F14 and G14 are
different from 0 ...
HTH
Cheers
Carim
D
David Biddulph
"Toppers" wrote:
I like to start with a balance in the row above. If I have a debit or
credit
on the next row, I would like to calculate the balance cell on that row to
give me the new total. If there is no entry, I would like the balance cell
on
that row to show 0 or stay blank. This should be like a regular check
register.
In which case:
=IF(AND(ISBLANK(F14),ISBLANK(G14)),"",H13+F14-G14)
T
Toppers
Try this:
=IF(OR(F3>0,G3>0),H2+F3-G3,0) and copy down
HOWEVER, I would have thought you would want the balance on every line; if
so then
in balance column
=H2+F3-G3 and copy down
F G H
Credit Debit Balance
100
100 200
0 <==== Should this not be 200?
50 -50 <== and this 150?
HTH
=IF(OR(F3>0,G3>0),H2+F3-G3,0) and copy down
HOWEVER, I would have thought you would want the balance on every line; if
so then
in balance column
=H2+F3-G3 and copy down
F G H
Credit Debit Balance
100
100 200
0 <==== Should this not be 200?
50 -50 <== and this 150?
HTH
H
Horst
That didn't work. This formula enters the latest total all the way down the
balance of the page.
balance of the page.
H
Horst
This still fills in the balance of the column.
David Biddulph said:In which case:
=IF(AND(ISBLANK(F14),ISBLANK(G14)),"",H13+F14-G14)
H
Horst
Great job. That formula worked. Thank you very much.
H
Horst
I couldn't get this formula to work
R
Ragdyer
Then try this:
=IF(OR(F14<>"",G14<>""),INDEX($H$3:H13,MATCH(MAX($H$3:H13)+1,$H$3:H13))+F14-
G14,"")
And copy down as needed.
=IF(OR(F14<>"",G14<>""),INDEX($H$3:H13,MATCH(MAX($H$3:H13)+1,$H$3:H13))+F14-
G14,"")
And copy down as needed.
H
Horst
David Biddulph
I don't know if you received my reply but your formula worked perfect for
what I needed. Great job, I appreciated your help.
Horst
I don't know if you received my reply but your formula worked perfect for
what I needed. Great job, I appreciated your help.
Horst