Well beyond what I had hoped for. Thanks SO much!

"Mike" wrote:

Try this
Put this into cell B3 And then type yes or no into cell A3
and if cell A3 is Blank then says Must Enter Yes Or No Into Cell A3
=IF(A3="YES",A1*A2,IF(A3="NO",B1*B2,"Must Enter Yes Or No Into Cell A3"))

"Phoebe" wrote:

I have employees put data into a spreadsheet already created. I would like
to have one cell in which they answer yes or no, and then create a formula
dependent on that answer. So if "yes", then A1*A2, and if "no" B1*B2 (for
instances). I would be so grateful for any ideas?