blakeboyuk
New Member
- Joined
- Mar 5, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Good morning,
Unfortunately the wind whistles through my ears at times and I struggle to comprehend even basic excel formula logic.
One such example is that I have a number of scenarios below which determine whether an order is defined as a HIT or a MISS.
The main question is was the part ordered and picked before the cutoff meaning its a HIT. This gets a little more complicated and I need to find a formula to account for orders placed after cutoff and picked the following day which are also HITS. When I've been attempting this thus far I get "too many arguments for this function" error message.
Can any one help offer some advice on how to do this?
Thanks so much
David
Unfortunately the wind whistles through my ears at times and I struggle to comprehend even basic excel formula logic.
One such example is that I have a number of scenarios below which determine whether an order is defined as a HIT or a MISS.
The main question is was the part ordered and picked before the cutoff meaning its a HIT. This gets a little more complicated and I need to find a formula to account for orders placed after cutoff and picked the following day which are also HITS. When I've been attempting this thus far I get "too many arguments for this function" error message.
Can any one help offer some advice on how to do this?
Thanks so much
David
Order Number | Order Placed? | Pick Date | Pick Time | Status |
110354220 | Ordered after cutoff | Picked the following day | Picked before cutoff | HIT |
110250140 | Ordered before cutoff | Picked on the same day | Picked before cutoff | HIT |
110307676 | Ordered before cutoff | Picked on the same day | Picked after cutoff | Miss |
110366617 | Ordered after cutoff | Picked the following day | Picked after cutoff | Miss |