# Multi-condition Judgment of WPS table using interval

Source: Internet
Author: User

① First we start the WPS table, prepare the data source, enter the formula in the cell: =lookup (a2,{0,19.999,39.999,59.999,69.999,79.999,89.999,100.0001},{"Waste food", "sad", " Fail ", pass", "good", "excellent", "best", "Reverse Day"}).

② Some people would say that if the IF function is not much simpler, do you ever think that if the number of nested arrays is up to 7 layers, more than can not be done.

③ Get the result, the effect is as follows:

④ in the formula, you need to make a decision about whether to be square brackets or parentheses, and then decide whether to use the <,> or ≤,≥ to compare the formula in B2 as follows: {=index (\$I \$: \$I \$11,match (\$D \$: \$D 1,if "[, \$11= \$E \$: \$E \$11,a2> \$E \$ \$E \$11) *if (\$H \$: \$H \$11= "]", a2<= \$G \$: \$G \$11,a2< \$G \$: \$G \$11)

Related Keywords:
Related Article

## E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

## Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

## Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD