=IFS(G3="DARK RED INCLINING","LONG",TRUE,FALSE,BLANK,H3="GREEN ABOVE RED","LONG",TRUE,FALSE,BLANK,I3="GREEN","LONG",TRUE,FALSE,BLANK,)
this is what i have at the min it working saying long but if 1 of the 3 cells are blank it still saying longĀ
i need G3 H3 and I3 to all be there for the result to be true but at the min it just saying long in F3 when there blankĀ