Excel Nested IF Function With 3 Conditions
Hi All,
i am new in here, I have a question on excel, currently I have the below raw data.
PartNumber Description Q'ty Non-All Allocation Pick Pack Cargo Shipped
E22 REARROOF 30 3 0 0 0 0 27
FF46 AUDISET 1 1 0 0 0 0 0
D436 CABLE 1 0 1 0 0 0 0
I would like to write an IF statment, if Qty minus Non-all = 0 means Non-All
if Qty minus Allocation, Pick, Pack, Cargo and shipped = 0 means Allocated
if Qty minus non-all <>0 and Qty minus Allocation, pick, pack, cargo <>0 means Partial allocated
How can I solve this in one IF statment please? Thanks!
