Hi Expert,
Below is my formula in excel ,
=IF($E$10<97,"Threshold",IF($E$10<98,"Min",IF($E$10<99,"Target",IF($E$10<100"Exceed",IF($E$10>99,"Stretch","")))))
My problem is, if the selected cell is EMPTY or ABOVE " 0 " then the result should appear dash " - " instead of Threshold
Anyone can help me .... i tried many option but still failed ..... I attached the sample for ease of ref.
Hope someone can help me ....
Thank you....