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