ExcelBanter - Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/447714-formulas.html)

smiling_smiler

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.

Claus Busch

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

Claus Busch

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

All times are GMT +1. The time now is 07:05 PM.