IF formula
 

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?

IF formula
 

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?

IF formula
 

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?

IF formula
 

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?

IF formula
 

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?

IF formula
 

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?

IF formula
 

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?