Add another IF statement if cell = "No RAG"

dtech1335 

You can add additional conditions to your formula using the IF function to check if W3 is "No RAG" or if X3 is blank. Here is an updated formula that includes these conditions:

=IF(W3 = "No RAG", "#N/A", IF(ISBLANK(X3), "#N/A", IF(W3 = "Decrease", IF(X3 > V3, "Red", IF(X3 <= R3, "Green", "Amber")), IF(X3 < V3, "Red", IF(X3 >= R3, "Green", "Amber")) )))

This formula will first check if W3 is "No RAG." If it is, it returns "#N/A." If not, it proceeds to check if X3 is blank. If X3 is blank, it also returns "#N/A." If neither of these conditions is met, it then evaluates the conditions based on the values in X3, V3, and R3 and returns the appropriate result.

Formularbeginn

The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.