Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
=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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
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. -- David Biddulph "becky250" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Datevlaue function/ day/month/year function | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |