| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula
That returns different values for a cell that contains a yes, no or N/A.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula
=IF(ISNA(A1),3,IF(A1="yes",1,IF(A1="no",2,"somethi ng else")))
-- Kind regards, Niek Otten Microsoft MVP - Excel "Trikester824" wrote in message ... | That returns different values for a cell that contains a yes, no or N/A. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula
=IF(ISNA(A1),"Result for N/A",IF(A1="yes","Result for
yes",IF(A1="no","Result for no","Result for other inputs"))) -- David Biddulph "Trikester824" wrote in message ... That returns different values for a cell that contains a yes, no or N/A. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula
Possibly one way:
=LOOKUP(A1,{"N/A","no","yes"},{"Not Applicable","N","Y"}) -- "Trikester824" wrote in message ... That returns different values for a cell that contains a yes, no or N/A. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula
If you want to change the contents of a cell based on what is currently in
that same cell, you will need VBA programming. Post back if this is what you want. HTH Otto "Trikester824" wrote in message ... That returns different values for a cell that contains a yes, no or N/A. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formula? | New Users to Excel | |||
| i'd like to create a formula | Excel Discussion (Misc queries) | |||
| How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
| How do a create a formula that if a1=rh than c1=13 | Excel Worksheet Functions | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Linear Mode
