I am trying to create a formula to enter data in a specific cell based on the value of another cell. There are 3 conditions that need to be address.

Here is the formula that needs to be fixed: =IF(I3<5,“Low”,IF(I3=>4<9,"Medium”,IFI3>8"High”))

Alternately: =IF(I3<5,“Low”,IF(I3=>4<9,"Medium”,"High”))

This formula works but only returns the first two values of “Low” and “Medium”. I cannot figure out how to fix this.