=IF (OR(AA4="FL",AA4="F1"),"D" AA4)

regards,
Stefi

€žbecky250€� ezt Ã*rta:

I have a spreadsheet whereby i calculate whether the employee has worked
Dayshift (D) or Twilight Shift (T), based on the times. However sometimes the
empoloyees type in FL or F1 (for Flexi-time) and i need to change either of
these into D. I understand it is using the IF function, i.e. if they only
typed in FL i would enter: IF (AA4="FL","D" AA4) but i am not sure how to do
this for both FL and F1 in the same calculation.
I would appreciate any help. Thanks.