combine multiple "if" statements

[FROGGER24]

I need some help in combining the following formulas:
1). =IF(C2="aaaaa",((B2-A2)*24)-0.5)
2). =if((C2="bbbbb","cccccc",((B2-A2)*24)-4))
3. if none of the previous conditions exist then use this formula.. ((B2-A2)*24)-3).

Once again thanks for any help.

 

[JoeMo]

If none of the previous conditions exist it can either be:

((B2-A2)*24)-4

OR

((B2-A2)*24)-3

But not both.

 

[FROGGER24]

Joe, thanks for your reply. If conditions A,B or C does not exist then conditon D will be ((B2-A2)*24)-3

The formula is looking at product streams that we load. Each stream takes various amount of time to perform a task.
Condition A will deduct .5 hrs
Conditions B and C will deduct 4 hrs
Condition D I need to deduct 3 hrs

 

[JoeMo]

Joe, thanks for your reply. If conditions A,B or C does not exist then conditon D will be ((B2-A2)*24)-3

The formula is looking at product streams that we load. Each stream takes various amount of time to perform a task.
Condition A will deduct .5 hrs
Conditions B and C will deduct 4 hrs
Condition D I need to deduct 3 hrs

Maybe you mean if C2 = "bbbbb" OR "cccccc" That's one condition not two. In that case try:

=IF(C2="aaaaa",((B2-A2)*24)-0.5,IF(OR(C2="bbbbb",C2="cccccc"),(B2-A2)*24-4,(B2-A2)*24-3))

 

[ukmikeb]

Hi

Or :-

=(B2-A2)*24-IF(C2="aaaaa",0.5,IF(OR(C2={"bbbbb","cccccc"}),4,3))

hth

 

[FROGGER24]

Joe and Mike,
Thanks for your formulas they both worked in my limited testing that I did... thanks a bunch.