Need help with a formula
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.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Horst" wrote in message
...
That didn't work. This formula enters the latest total all the way down
the
balance of the page.
"Ragdyer" wrote:
Try this:
=IF(AND(F14,G14),H13+F14-G14,0)
And copy down as needed.
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Horst" wrote in message
...
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.
"Toppers" wrote:
..... 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
"Horst" wrote:
Can someone give me the right formula plase
IF(F14:G14=VALUE,SUM(H13+F14-G14),0)
|