IF function help

B

becky250

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.
 
D

David Biddulph

Are you sure you want to look for F1 (as in F number one), and not Fl (F
lower case L)? In the latter case, your existing formula will find it
(though you need to correct the syntax error, presumably a missing comma?).
If it is the former, then Stefi's OR() answer is what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Function Help 2
Justification function versus wide spaces 0
Count Duplicate Numbers 4
Problem with SET & REF function 0
Help with a formmula change in a "flag" parameter! 19
macro to list folders only, not files 3
If(not(A2="FL","AL".... ),"other",A2) IF(not help 3
Newbie Help - IF Yes No Function 0

Top