awaiting

Hi all, Looking for formula please In Column C I have 2 options In Process and Awaiting Process In Column D I have 4 options Repaired, Cannot be repaired, Awaiting Part, Log No. Below I have 2 In Process = Repaired, 1 In Process = Cannot be repaired. 2 Awaiting Process = Awaiting Log No...

Dear friends and respected seniors, In excel 2003, i have this data in cells a1 = 1 b1 = + c1 = 2 In d1 i want calculation of a1 and b1 and c1, so answer in d3 must be 3, because 1+2=3. Similarly if value in b1 is -, then d1 must become -1 because 1-2 = -1, but I am not able to do it :( I tried...

Before we start, I know I can do this via vlookup but it is massively time consuming. You'll see why. The goal: to figure out when my product will arrive at my assembly centers. The issue: I have a spreadsheet from my freight forwarder. It looks like this: <tbody> PO SKU QTY Depart Date...

Hello, Can somebody tell me formula how to return date from column B in to column F for matching product with status awaiting? <colgroup><col span="2"><col span="2"><col><col span="4"></colgroup><tbody> <tbody> A B C E F Prodcut Date Status Product Date Apple 20/04/2018 Done Apple...