software

Can someone give me the right formula plase
IF(F14:G14=VALUE,SUM(H13 F14-G14),0)

=IF(F14 G14=123,H13 F14-G14,0) where lt;valuegt;=123

quot;Horstquot; wrote:

gt; Can someone give me the right formula plase
gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)

...... 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

quot;Horstquot; wrote:

gt; Can someone give me the right formula plase
gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)


Hi Horst,

Difficult to guess ...
could be
=IF(F14=G14,H13 F14-G14,0)

HTH
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=531317That 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.

quot;Toppersquot; wrote:

gt; ..... or do you mean...
gt;
gt; =if(OR(F14=value,G14=Value),H3 F13-G14),0)
gt;
gt; i.e if F14 OR G14 Value?
gt;
gt; If both F14 AND G14 = Value then change OR to AND
gt;
gt; =if(AND(F14=value,G14=Value),H3 F13-G14),0)
gt;
gt;
gt; HTH
gt;
gt; quot;Horstquot; wrote:
gt;
gt; gt; Can someone give me the right formula plase
gt; gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)

Please explain what you want to happen .. just giving a formula isn't
sufficient.

quot;Horstquot; wrote:

gt; That didn't work. I'm trying to create a running ledger but I don't want it
gt; to automaticaly to configure unless the next entry has been posted.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; ..... or do you mean...
gt; gt;
gt; gt; =if(OR(F14=value,G14=Value),H3 F13-G14),0)
gt; gt;
gt; gt; i.e if F14 OR G14 Value?
gt; gt;
gt; gt; If both F14 AND G14 = Value then change OR to AND
gt; gt;
gt; gt; =if(AND(F14=value,G14=Value),H3 F13-G14),0)
gt; gt;
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Horstquot; wrote:
gt; gt;
gt; gt; gt; Can someone give me the right formula plase
gt; gt; gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)

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.

quot;Toppersquot; wrote:

gt; Please explain what you want to happen .. just giving a formula isn't
gt; sufficient.
gt;
gt; quot;Horstquot; wrote:
gt;
gt; gt; That didn't work. I'm trying to create a running ledger but I don't want it
gt; gt; to automaticaly to configure unless the next entry has been posted.
gt; gt;
gt; gt; quot;Toppersquot; wrote:
gt; gt;
gt; gt; gt; ..... or do you mean...
gt; gt; gt;
gt; gt; gt; =if(OR(F14=value,G14=Value),H3 F13-G14),0)
gt; gt; gt;
gt; gt; gt; i.e if F14 OR G14 Value?
gt; gt; gt;
gt; gt; gt; If both F14 AND G14 = Value then change OR to AND
gt; gt; gt;
gt; gt; gt; =if(AND(F14=value,G14=Value),H3 F13-G14),0)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; quot;Horstquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Can someone give me the right formula plase
gt; gt; gt; gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)

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 !
---------------------------------------------------------------------------
quot;Horstquot; gt; wrote in message
...
gt; That didn't work. I'm trying to create a running ledger but I don't want
it
gt; to automaticaly to configure unless the next entry has been posted.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; ..... or do you mean...
gt; gt;
gt; gt; =if(OR(F14=value,G14=Value),H3 F13-G14),0)
gt; gt;
gt; gt; i.e if F14 OR G14 Value?
gt; gt;
gt; gt; If both F14 AND G14 = Value then change OR to AND
gt; gt;
gt; gt; =if(AND(F14=value,G14=Value),H3 F13-G14),0)
gt; gt;
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Horstquot; wrote:
gt; gt;
gt; gt; gt; Can someone give me the right formula plase
gt; gt; gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)
Hi,

If I may Toppers is right ... a clear explanation would help ...

=if(AND(F14lt;gt;0,G14lt;gt;0),H3 F13-G14),0)

This formula would perform the calculation only if both F14 and G14 are
different from 0 ...

HTH
Cheers
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=531317quot;Horstquot; gt; wrote in message
...

gt; quot;Toppersquot; wrote:

gt;gt; quot;Horstquot; wrote:

gt;gt; gt; quot;Toppersquot; wrote:

gt;gt; gt; gt; quot;Horstquot; wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; gt; Can someone give me the right formula plase
gt;gt; gt; gt; gt; IF(F14:G14=VALUE,SUM(H13 F14-G14),0)

gt;gt; gt;
gt;gt; gt; gt; ..... or do you mean...
gt;gt; gt; gt;
gt;gt; gt; gt; =if(OR(F14=value,G14=Value),H3 F13-G14),0)
gt;gt; gt; gt;
gt;gt; gt; gt; i.e if F14 OR G14 Value?
gt;gt; gt; gt;
gt;gt; gt; gt; If both F14 AND G14 = Value then change OR to AND
gt;gt; gt; gt;
gt;gt; gt; gt; =if(AND(F14=value,G14=Value),H3 F13-G14),0)

gt;gt; gt; That didn't work. I'm trying to create a running ledger but I don't
gt;gt; gt; want it
gt;gt; gt; to automaticaly to configure unless the next entry has been posted.

gt;gt; Please explain what you want to happen .. just giving a formula isn't
gt;gt; sufficient.

gt;I like to start with a balance in the row above. If I have a debit or
gt;credit
gt; on the next row, I would like to calculate the balance cell on that row to
gt; give me the new total. If there is no entry, I would like the balance cell
gt; on
gt; that row to show 0 or stay blank. This should be like a regular check
gt; register.

In which case:
=IF(AND(ISBLANK(F14),ISBLANK(G14)),quot;quot;,H13 F14-G14)
--
David Biddulph