One way:
=CHOOSE(OR(A4={"apple","pear","plum"})+OR(A4={"car rot","bean"})*2+OR(A4={"bun","cake","donut"})*3+1, A4,"fruit","veg","pastry")
Regards,
KL
"Jocko_MacDuff116" wrote in
message ...
Does anyone know how to build a formula as follows
if(a4='apple' or 'pear' or 'plum', then 'fruit' else
if(a4='carrot' or 'bean', then 'veg' else
if(a4='bun' or 'cake' or 'donut' then 'pastry' else a4)))
I have been unable to find satisfactory info re or & and as part of
functions.
|