Combining IF functions

[Scott82]

Hi guys, my brain hurts!

I am trying to combine these two statements that both work fine on their own!
=IF(ISBLANK('[Schedules Flexible worker.xls]Schedules'!$E$4:$E$12),"Call")
&
=IF('Availability IN'!D4="x","Call")

So that if both are true then "call"

I'm sure this is fairly easy but I've lost the will to live!

Many thanks

Scott

 

[Scott82]

No, you're right, it didn't even work on it's own! Doh!

I'm afraid the countif doesn't work either!

 

[Scott82]

As there are only 7 possible outocomes for boxes E4:E12, how does this look?
=IF(AND('[Schedules Flexible worker.xls]Schedules'!$E$4:$E$12,Giles,Millington,Shirley,Palmer,Fleming,Todhunter,Charlotte,Night,School),('Availability IN'!D4="x")"Call",Don't Call")

I've just tryed it and it's not working but thought it was a logical answer!

Scott

 

[Scott82]

Morley you are am STAR! thank you!