Hi, i have the following formula inplace.
=IF(L16>=3,"Inconsistent",IF(L16<1,"On track","Good"))
I need to change the formula so it only considers inconsistent, on track or Good , if cell M16 has a value greater than 100, if M16 is less than 100 the formula needs to return "on track"
I have...