Nesting Functions

  • Thread starter Thread starter Deanna
  • Start date Start date
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...
 
Ok, so when you put it that way!!! Thanks, I was making it way more
complicated than it needed to be...
 
Back
Top