trying to link 3 cell so they give a result in a 4th cell

0

=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Ā 

Answer
Discuss

Answers

0

I am not using Excel 2016 but here is an easier-to-read formula that should do what you want:

=IF(AND(G3="DARK RED INCLINING",H3="GREEN ABOVE RED",I3="GREEN"),"LONG","")

This just uses the IF function and the AND function.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login