Hi! I have looked all over for an answer to this so I apologize if it has been answered elsewhere.

I am trying to create a nested if statement in a Word table based on a drop down box in one of the table's cells.

Cell B2: Drop box (High, Medium, Low)
Cell B3: Any numerical value (We can use 100 for the example)
Cell B4: If formula

I have (successfully!) created this formula in excel, but I can't seem to get it right in Word. Instead of posting my terrible attempts in Word I have included the Excel formula below. Could someone please help me with the proper Word formula???

=IF(B2="High",B3/(1+B3*0.2^2),IF(B2="Medium",B3/(1+B3*0.1^2),IF(B2="Low",B6/(1+B6*0.05^2),"FALSE")))