View Single Post
  #1   Report Post  
Jocko_MacDuff116
 
Posts: n/a
Default HD I build funct @if cell=AorBorC then ...else if cell=DorE then

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.