I am quite new to Excel and I am currently using Excel 2013 at work. What I am in need of is probably extremely simple for most people on this forum so I am hopeful that I can get some help with this.
What I need:
Use of IF, AND, OR formula
I have data in Column I which has 5 different items. I also have data in Column P which either has (No Value) or (Part #) the part # can be anything.
I need is a formula that I would put into Column H2 that will do the following:
Check if data in Cell I2 = "Delivery" or "Returns" if so, check if data in cell P2 = "No Value" or "" and if data in P2 = "No Value" place a 0 in cell H2 but if P2 has anything other than "No Value" return 1 in cell H2
Any help is greatly appreciated. This has taught me that I need to do way more training in Excel to be better at my job.
What I need:
Use of IF, AND, OR formula
I have data in Column I which has 5 different items. I also have data in Column P which either has (No Value) or (Part #) the part # can be anything.
I need is a formula that I would put into Column H2 that will do the following:
Check if data in Cell I2 = "Delivery" or "Returns" if so, check if data in cell P2 = "No Value" or "" and if data in P2 = "No Value" place a 0 in cell H2 but if P2 has anything other than "No Value" return 1 in cell H2
Any help is greatly appreciated. This has taught me that I need to do way more training in Excel to be better at my job.