Forum Discussion

dtech1335's avatar
dtech1335
Copper Contributor
Oct 06, 2023

Add another IF statement if cell = "No RAG"

Hi, 

 

I have a formula below which works, however I also want to add:

IF W3 = "No RAG" return "#N/A" and IF cell X3 is blank return "#N/A".

 

 

 

IF(W3 = "Decrease",
IFNA(IF(ISBLANK(X3),"#N/A",
IF(X3>V3,"Red",IF(X3<=R3,"Green","Amber"))),"#N/A"),
 
IFNA(IF(ISBLANK(X3),"#N/A",
IF(X3<V3,"Red",IF(X3>=R3,"Green","Amber"))),"#N/A"))
excel
Excel for web
Formulas and Functions
training

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 06, 2023

    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.

Resources