if formula help

[markster]

Basically I want this formula to say that if Q422 =Fixed Term or Agency Staff then to use P422 – I tried to put in the OR and it didn’t work – any ideas?

=IF('Sheet 1'!Q422="Fixed Term",'Sheet 1'!P422,"")
Cheers
Mark

 

[Norie]

Try this

=IF(OR('Sheet 1'!Q422="Fixed Term", 'Sheet 1'!Q422="Agency Staff),'Sheet 1'!P422,"")