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 |