IF formula

[Phoebe]

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?

 

[Mike]

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

 

[AKphidelt]

Try

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

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

 

[Pete_UK]

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

 

[Phoebe]

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

 

[Phoebe]

Thank you so much for your help!

Try

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

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

 

[Phoebe]

Very helpful. Thank you so much!

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