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.

Hi, in A2: =IF(C2="ALL",C2,"") in B2: =IF(C2<>"ALL",C2,"") . Hope it helps

Wooooo hooooooo many thanks for your super quick response!!!!!!!!