Formulas

[smiling_smiler]

Hi,

Is there a way of putting an if statement in to say that if column C ha
an answer of ALL then put that answer in column A if column C say
anything other than ALL then put it in column B?

Many Thanks for your answers

 

[Claus Busch]

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

 

[Claus Busch]

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