Excel if formula maybe

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
=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.
 
Back
Top