[Excel] Conditional formula issue

Issue

Suppose I have two column, in the first one we can enter several types of items: water, soil, noise, odor, waste and air.
In the second one we can enter the numbers 1, 3...10.

Here the condition:

If column 1 =  WASTE OR WATER OR NOISE -> 1 appears in column 2  
If column 1 =  ODOR OR AIR-> 3 appears in column 2  
If column 1 = SOIL ->10 appears in column 2

What formula can be used?

Solution

Assuming that B5 is where the item is displayed:

=IF(Or(B5="WATER";B5="WASTE";B5="NOISE");1;IF(OR(B5="ODOR";B5="AIR");3;10))

Thanks to lentz for this tip.

See also

Knowledge communities.

• Forum
• Excel forum
• Office software forum
• Word forum

This document entitled « Excel - Conditional formula issue » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.