If formula puzzle

[Godders199]

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 been playing for ages, but cant get anything to work.

Any help would be appreciated.

 

[njimack]

=IF(M16<100,"On track",IF(L16>=3, "Inconsistent",IF(L16<1,"On track","Good")))

 

[steve the fish]

Like this?

=IF(M16<100,"On track",IF(L16>=3,"Inconsistent",IF(L16<1,"On track","Good")))

 

[steve the fish]

Or use an OR:

=IF(OR(M16<100,L16<1),"On track",IF(L16>=3,"Inconsistent","Good"))

 

[Godders199]

thanks works ...

 

[Godders199]

thanks both work