| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
