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 