realcutie1
New Member
- Joined
- Jul 22, 2013
- Messages
- 12
Hello,
I am in logistics and I can't seem to figure out this formula in excel.
So, I have Actual Arrival times of trucks in Column E which is inputed by one of my employees. I have set up column F to display a "O" if the time is in E column is less than or equal to time in C column. It will display an "X" if it is greater than that time. I also did conditional formatting so that if it displays a "O", the cell is green and if it displays and "X", the cell is red. Only problem is that I dont want anything in the cell if nothing is input into column E. I want it to remain blank until something is entered.
The formula I used already was =IF(OR(E4<C4,E4=C4),"O","X") F.
Currently column F stays green with a "O" until something is put in column E to make it change to red and an "X".
See my spreadsheet below:
<TBODY>
</TBODY>
I am in logistics and I can't seem to figure out this formula in excel.
So, I have Actual Arrival times of trucks in Column E which is inputed by one of my employees. I have set up column F to display a "O" if the time is in E column is less than or equal to time in C column. It will display an "X" if it is greater than that time. I also did conditional formatting so that if it displays a "O", the cell is green and if it displays and "X", the cell is red. Only problem is that I dont want anything in the cell if nothing is input into column E. I want it to remain blank until something is entered.
The formula I used already was =IF(OR(E4<C4,E4=C4),"O","X") F.
Currently column F stays green with a "O" until something is put in column E to make it change to red and an "X".
See my spreadsheet below:
| Route</SPAN> | Stage time</SPAN> | Window time</SPAN> | Gate Arrival</SPAN> | ARRIVAL STATUS</SPAN> | Gate Departure</SPAN> | DEPARTURE STATUS</SPAN> | |
| DAY SHIFT</SPAN> | In</SPAN> | Out</SPAN> | |||||
| TMMC CWDO - 03</SPAN> | 0030 - 0130</SPAN> | 500</SPAN> | 600</SPAN> | O | O | ||
| TMMI IDLW - 02</SPAN> | 0030 - 0130</SPAN> | 500</SPAN> | 600</SPAN> | O | O | ||
| TMMK KIPL - 02</SPAN> | 0030 - 0130</SPAN> | 600</SPAN> | 700</SPAN> | O | O | ||
| SIA UDG - 01</SPAN> | 0700 - 0800</SPAN> | 800</SPAN> | 900</SPAN> | O | O | ||
| TMMC CWDO - 04</SPAN> | 0800 - 0900</SPAN> | 900</SPAN> | 100</SPAN> | O | O | ||
| TMMC CWDO - 05</SPAN> | 0900 - 1000</SPAN> | 1045</SPAN> | 1145</SPAN> | O | O | ||
| TMMI IDAF - 01</SPAN> | 1230 - 1300</SPAN> | 1300</SPAN> | 1320</SPAN> | O | O | ||
| TMMI IDLW - 03</SPAN> | 1200 - 1300</SPAN> | 1300</SPAN> | 1400</SPAN> | O | O |
<TBODY>
</TBODY>
