Nesting Functions

D

Deanna

I'm trying to combine AND, OR, and IF for the first time, and I'm getting
lost in the parentheses.

Here's the broader formula I'm trying to fill in:
=IF(AND(Fleet,Date Completed),1,0)

where Fleet needs to be filled in with:
OR($D8="HOS WH",$D8="HOS ENG")

and Date Completed needs to be filled in with:
AND($I8>=40179,$I8<=40209)

I've tested the formulas for Fleet and Date Completed as their own logical
statements, and they both work. I can't get them combined in the larger
formula, though.

Any assistance would be appreciated!

Thanks...
 
D

David Biddulph

You forgot to tell us what you tried as the combined formula, and in what
way it didn't work.

Presumably =IF(AND(OR($D8="HOS WH",$D8="HOS
ENG"),AND($I8>=40179,$I8<=40209)),1,0)
or just
=--AND(OR($D8="HOS WH",$D8="HOS ENG"),AND($I8>=40179,$I8<=40209)) ?
 
D

Deanna

Ok, so when you put it that way!!! Thanks, I was making it way more
complicated than it needed to be...
 
Top