software

I am trying to write a formula that contains multiple conditions and I need
help. If column E is equal to column C 3, then I want it to take the total
of (E F)-(C D) and subtract 62.5/24... AND if column E is equal to column
C 1, then I want it to only subtract 14.5/24. The formula that I have now
inserts the word FALSE instead of a number.

Here is what I have so far:

=IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),(E4 F4)-(C4 D4))=IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4))

You want to nest your IF statements. Your current formula asks if the output
of the two IF statemets are equal.

=IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4)))

Jerry

quot;TLAngeloquot; wrote:

gt; I am trying to write a formula that contains multiple conditions and I need
gt; help. If column E is equal to column C 3, then I want it to take the total
gt; of (E F)-(C D) and subtract 62.5/24... AND if column E is equal to column
gt; C 1, then I want it to only subtract 14.5/24. The formula that I have now
gt; inserts the word FALSE instead of a number.
gt;
gt; Here is what I have so far:
gt;
gt; =IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),(E4 F4)-(C4 D4))=IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4))

Thank you for your reply. I actually figured it out right after I sent this
post... isn't that Murphy's Law or something!?

quot;Jerry W. Lewisquot; wrote:

gt; You want to nest your IF statements. Your current formula asks if the output
gt; of the two IF statemets are equal.
gt;
gt; =IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4)))
gt;
gt; Jerry
gt;
gt; quot;TLAngeloquot; wrote:
gt;
gt; gt; I am trying to write a formula that contains multiple conditions and I need
gt; gt; help. If column E is equal to column C 3, then I want it to take the total
gt; gt; of (E F)-(C D) and subtract 62.5/24... AND if column E is equal to column
gt; gt; C 1, then I want it to only subtract 14.5/24. The formula that I have now
gt; gt; inserts the word FALSE instead of a number.
gt; gt;
gt; gt; Here is what I have so far:
gt; gt;
gt; gt; =IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),(E4 F4)-(C4 D4))=IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4))

If you want, another option might be to factor out the common term:

=(E4 F4)-(C4 D4) - IF(C4 3=E4,62.5/24,IF(C4 1=E4,14.5/24,0))

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;TLAngeloquot; gt; wrote in message
news
gt; Thank you for your reply. I actually figured it out right after I sent
gt; this
gt; post... isn't that Murphy's Law or something!?
gt;
gt; quot;Jerry W. Lewisquot; wrote:
gt;
gt;gt; You want to nest your IF statements. Your current formula asks if the
gt;gt; output
gt;gt; of the two IF statemets are equal.
gt;gt;
gt;gt; =IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4)))
gt;gt;
gt;gt; Jerry
gt;gt;
gt;gt; quot;TLAngeloquot; wrote:
gt;gt;
gt;gt; gt; I am trying to write a formula that contains multiple conditions and I
gt;gt; gt; need
gt;gt; gt; help. If column E is equal to column C 3, then I want it to take the
gt;gt; gt; total
gt;gt; gt; of (E F)-(C D) and subtract 62.5/24... AND if column E is equal to
gt;gt; gt; column
gt;gt; gt; C 1, then I want it to only subtract 14.5/24. The formula that I have
gt;gt; gt; now
gt;gt; gt; inserts the word FALSE instead of a number.
gt;gt; gt;
gt;gt; gt; Here is what I have so far:
gt;gt; gt;
gt;gt; gt; =IF(C4 3=E4,(E4 F4)-(C4 D4)-(62.5/24),(E4 F4)-(C4 D4))=IF(C4 1=E4,(E4 F4)-(C4 D4)-(14.5/24),(E4 F4)-(C4 D4))