| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formulas
Hi,
Is there a way of putting an if statement in to say that if column C has an answer of ALL then put that answer in column A if column C says anything other than ALL then put it in column B? Many Thanks for your answers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
Am Fri, 23 Nov 2012 17:35:26 +0000 schrieb smiling_smiler:
Hi, Is there a way of putting an if statement in to say that if column C has an answer of ALL then put that answer in column A if column C says anything other than ALL then put it in column B? Many Thanks for your answers. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
Hi,
Am Fri, 23 Nov 2012 17:35:26 +0000 schrieb smiling_smiler: Is there a way of putting an if statement in to say that if column C has an answer of ALL then put that answer in column A if column C says anything other than ALL then put it in column B? in A1 try: =IF(C1="ALL",C1,"") in B1 try: =IF(C1<"ALL",C1,"") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming | |||
Hybrid Mode
