Problems with IF statements

[Carl24488]

Hi all,

I'm trying to create a new holiday spreadsheet which automatically changes linked cells to 'Restricted' when a Holiday is inserted a different cell. So for example if one person was on holiday on a given date the people that cannot have that day off are automatically shown 'restricted' in the corresponding cell.

Now this working with cells which are only looking at one other cell! But not for the 2 cells which are looking at more than one. Also some cells are looking at cells which are looking at them which is creating 'circular references'.

the formula I have in the cell which is working is :=IF(E6=R$8,"Restricted","-")
the cell which isnt working : =IF(OR(J6=R$8,I6=R$8,F6=R$8),"Restricted","-")

Is it possible to post the file for others to look at.

Thank you to all who help me because i'm at wits end.

[Azam Ali]

In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button

[Carl24488]

Planner - Holidays.xlsx

This is the file, Thanks Azam.

Also having problems with the CountIF on the second tab