Hello guys,
need your help
i have the below table
<tbody>
1
A
B
C
D
2
Qty
Received
Missing
Completed
3
50
10
=A3-B3
</tbody>
i need to create a formula in D3 that will do the following:
IF C3 is empty D3 is empty
IF C3 is lower then A2 = Pending
IF C3 is equil to B3 = Completed...