Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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