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?

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?

Try

=IF(Cell="yes",A1*A2,B1*B2)

Change Cell to the cell that has the yes or no answer.

"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?

Assume that C1 is used for the Yes/No input. You should apply Data
validation to that cell to restrict the input to only these values
(rather than Y or N, for example). Then you can use this formula:

=IF(C1="","",IF(C1="Yes",A1*A2,B1*B2))

The cell with this formula in will appear empty if C1 is empty.

Hope this helps.

Pete

On May 17, 1:14 am, 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?

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?

Thank you so much for your help!

"AKphidelt" wrote:

Try

=IF(Cell="yes",A1*A2,B1*B2)

Change Cell to the cell that has the yes or no answer.

"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?

Very helpful. Thank you so much!

"Pete_UK" wrote:

Assume that C1 is used for the Yes/No input. You should apply Data
validation to that cell to restrict the input to only these values
(rather than Y or N, for example). Then you can use this formula:

=IF(C1="","",IF(C1="Yes",A1*A2,B1*B2))

The cell with this formula in will appear empty if C1 is empty.

Hope this helps.

Pete

On May 17, 1:14 am, 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?