Hello all.
I am attempting to make a spreadsheet for my job where certain questions needs to be answered Yes or No. I am using a drop down for the Yes / No.
I have one cell where if anyone answers one of the questions "Yes" it says "Please Proceed" and if you answer "No", it says "Stop the Test". The problem, I have 7 questions that someone has to answer.
I know it requires the use of more than one "If" statement so that all the Yes/No answers get looked at. But I can't get the particulars figured out.
Cells M16 to M22 have the Yes / No answer and cell M24 is the cell I am using for the statements "Please Proceed" and "Stop the Test"
I have the basic formula in cell M24 of =IF(M16= "Yes", "Please Proceed", "Stop the Test")
I know I am close..and feel dumb asking, but can't figure it out.
Thanks all.
Dave
Bookmarks