I am having trouble working through some conditional formulas. Any Help would be appreciated. I would be ok with using other cells for formulas if needed to provide the solution.
Option A: If any of the cells in D10:D13 or E10:E13 are blank, I would like D14 & E14 to be blank also. If all of those cells contain a number, even if "0", then I would like each to return a specific answer. See the conditional formulas below.
Option B: If all cells in D10:D13 & E10:E13 don't have a numerical value, then cell C6 should show a blank. If all of the cells have numerical values, then it should show the sum of D15+E15
-- removed inline image ---
Option A: If any of the cells in D10:D13 or E10:E13 are blank, I would like D14 & E14 to be blank also. If all of those cells contain a number, even if "0", then I would like each to return a specific answer. See the conditional formulas below.
Option B: If all cells in D10:D13 & E10:E13 don't have a numerical value, then cell C6 should show a blank. If all of the cells have numerical values, then it should show the sum of D15+E15
-- removed inline image ---