MULTIPLE CONDITIONS FORMULA

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

"TLAngelo" wrote:

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

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

"Jerry W. Lewis" wrote:

> 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
>
> "TLAngelo" wrote:
>
> > 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))

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. :>)
Dana DeLouis
Windows XP, Office 2003


"TLAngelo" <[email protected]> wrote in message
news:[email protected]...
> Thank you for your reply. I actually figured it out right after I sent
> this
> post... isn't that Murphy's Law or something!?
>
> "Jerry W. Lewis" wrote:
>
>> 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
>>
>> "TLAngelo" wrote:
>>
>> > 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))