How to write If and ElseIf formulas with 4 criterias

Hi @Clara .​,

Try this;

IF [SUM XX] + [BB]+ [FF] = 0 THEN 'Yes BBFF'
 
ELSEIF  [SUM XX] + [BB]  = 0 THEN 'YesBB'
 
ELSEIF  [SUM XX] + [FF] = 0 THEN 'YesFF'
 
ELSE 'Others' END 
 

I hope this helps.