U can use this one also in G7:
=IF((F7>=D7)*(F7<=E7),"Normal",IF(F7>E7,"Yes","Fail"))
Try...........
View attachment 64866
In G7, enter formula :
=IF(F7="","",LOOKUP(F7,{0;200000;288889},{"fail";"normal";"Yes"}))
Regards
Try...........
View attachment 64866
In G7, enter formula :
=IF(F7="","",LOOKUP(F7,{0;200000;288889},{"fail";"normal";"Yes"}))
Regards
Then, the formula changed to :
=IF(F7="","",LOOKUP(F7,{0;200000;200000.01;288888},{"fail";"maintain";"rise";"Yes"}))
View attachment 64867
Regards