IF / IFS Formula to highlight required Action

Hi, I am just looking for help with an IF formula. The formula is needed to give me a required action depending on outcome.

If the ACTUAL is between the TARGET and UPPER - "double check"

If the ACTUAL is over the UPPER - "add water"

If the ACTUAL is between the TARGET and LOWER - "ok"

I have tried the below formulas to no avail and i cannot seem to figure it out.

=IF(I2>F2, "Add Water",IF(I2<F2>G2, "Double Check", "OK"))

=IF(I2>F2, "Add Water",IF(I2<F2 and>G2, "Double Check", "OK"))


Photos attached

If anything needs clarifying just let me know.

Hi Wayne,

Thanks for the help!

Just in relation to if its < than target but > than lower - "OK".

This doesn't seem to be working correctly.

New formula : =IF(I2>F2, "Add Water", IF(AND(I2<F2, F2>G2), "Double Check", "OK"))

yes, as it should be "OK" - as falls within the condition if ACTUAL is between the TARGET and LOWER