Excel if formula maybe

[Guest]

I want a formula to do this
if c2 = Holiday or Bank Hol then display 8 (in the cell im
typing the formula) if not do another formula (on the info
in c2)

 

[Aladin Akyurek]

=IF(ISNUMBER(MATCH(C2,Holidays,0)),8,X)

where Holidays refers to a range housing (bank) holiday dates and X an
expression that you want to evaluate when C2 is not a holiday date.