In excel use a set of embedded if statements to create a single formula that wil
ID: 3811987 • Letter: I
Question
In excel use a set of embedded if statements to create a single formula that will calculate the Danger level of the following water samples. Samples taken before September 1, 2008 samples above 300 ppm have a "High" danger level, samples between 200 and 300 have a "Medium" level, and samples below 200 have a "low" level. Samples taken after September 1, 2008 samples above 400 ppm have a "High" danger level, samples between 300 and 400 have a "Medium" level, and samples below 300 have a "low" level.
Explanation / Answer
=IF(A1<DATE(2008,9,1),IF(B1>300,"High",IF(B1>=200,"Medium","Low")),IF(B1>400,"High",IF(B1>=300,"Medium","Low")))
09-01-08 300 Medium 10-09-2009 500 High 10-01-08 201 Low