# Multiple condition formula

• 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....

## Files

• Above 0 up to what figure? You have stated that under 97 should return Threshold.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• Hello,

With your reference range sorted in descending order, you can use a simple match function ...

Hope this will help

Edit : Hello Ali

Code
1. =IF(OR(G8="",G8=0),"-",INDEX(\$D\$7:\$D\$11,MATCH(G8,\$C\$7:\$C\$11,-1)))

## Files

• Test Nik.xlsx

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner

Edited once, last by Carim ().

• Hello,

But just noticed your thread title with multiple conditions ... whereas there seems to be only ONE reference table ...

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner