Hello,
I am trying to write an "if" statement that will take into account 3 conditions that are on the worksheet one and rearrange the information on worksheet two based on station # and time. I need to be able to have the AM names/times applied to the stations in the AM section and the PM times/names applied to the PM station.
=if(and(C#=S#,B#<time(13.0.0)), A#, False)
That is for an AM shift
=if(and(C#=S#,B#>time(13.0.0)), A#, False)
That is for a PM shift
Where C# refers to the station, B# refers to the time they work, and A# refers to their name. Any idea how I can get this to place the AM people in the correct AM spots and the PM in the correct pm spots?
Configuration: Windows Vista Internet Explorer 8.0
Best answers for « EXCEL IF STATEMENT » in :
Colouring cells on conditions ShowColouring cells on conditions
There are many pratical functions under Excel which is not commonly used.
Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Basic Excel Formulas 2 ShowBasic Excel Formulas 2
We saw the SI function
Function and is also interesting. Combined with SI, this gives:
= IF (AND (condition1; condition2 ;....... conditionZ) true false)
displays on the various conditions to be verified (eg...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell
If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened.
Simply type "ctrl" + ";" in the...
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs.
This application will be necessary in case you should have received an...
Spreadsheets - The Excel Interface ShowExcel Introduction
Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension).
A Excel...
See also Plus
Comparing multiple integers with if statement- Delete row in excel if=y
- Excel 2007 if else function
- Excel compare columns if statement
- Excel conditional formatting if statement
- Excel formula if contains letter then
- Excel how to make else if statements
- Excel if starts with
- Excel if statement strings
- Excel if value then a-b
- Excel macro if statement
- Excel script to hide rows if condition met
- How do i get rid of a true and or false statement out of an if statement
- How do you calculate bonus in excel with if statements
- If i have two columuns of info in excel how do i delete one in the other
- If statements in excel
- Nested if statement excel
- Vb if statements two value
