I can't figure out the correct If statement ( i think that would the best solution) for the sample spreadsheet attached. I need cells B6 and B7 to change based on the selection of the dropdowns in B1 through B3. I've hardcoded the correct answer in B6 and B7 to illustrate what my answer needs to be.
Thank you for your help - I am stuck.
Thank you for your help - I am stuck.