Question

WRITE EXCEL FORMULA PLEASE!!! Enter a formula that uses the data from column H to determine the radiation level. If the radiation is less than 0.3 W/m, the level is low; if the radiation is from 0.3 W/m to 0.6 W/m, the level is medium; if the radiation is more than 0.6 W/m, the level is high.

a) =IF(H1<0.3, Low, IF(H1<=0.6, Medium, High))
b) =IF(H1<=0.3, Low, IF(H1<=0.6, Medium, High))
c) =IF(H1<0.3, Low, IF(H1<0.6, Medium, High))
d) =IF(H1<=0.3, Low, IF(H1<0.6, Medium, High))

Answer 1

The correct formula to use is =IF(H1<=0.3, Low, IF(H1<=0.6, Medium, High)).

Step-by-step explanation:

The correct formula to use in this case is option b) =IF(H1<=0.3, Low, IF(H1<=0.6, Medium, High)).

This formula uses the IF function to check the value in cell H1. If the value is less than or equal to 0.3, it returns 'Low'. If it is greater than 0.3 but less than or equal to 0.6, it returns 'Medium'. And if it is greater than 0.6, it returns 'High'.

For example, if the value in cell H1 is 0.25, the formula will return 'Low'. If the value is 0.4, the formula will return 'Medium'. And if the value is 0.8, the formula will return 'High'.