How can I combine these 3 conditions in a single Excel formula?

Question

I need to create an excel formula based on the following:

1. If Cell >= 500 Then the Cell text should be "Critical"
2. If Cell >= 400 Then the cell text should be "Medium"
3. If cell < 400 then the cell text should be "Normal"

I currently have

=IF(OFFSET(H2;0;-1)>500;"Critical"; IF(OFFSET(H2;0;-1)<=500;"Normal";))

But as soon as i add the third condition it doesn't accept it and gives me errors and messes up the whole thing.

Answer 1

You don't need a third condition. You need to do this:

Is value >= 500? If yes then "Critical" else continue:
Is value >= 400? If yes then "Medium" else "Normal"

So you need to do the following:

IF( DESREF(H2;0;-1)>=500 ; "Critical" ; IF( DESREF(H2;0;-1)>=400 ; "Medium" ; "Normal ) )

And, with a line-break for readability:

IF( DESREF(H2;0;-1)>=500 ; "Critical" ; 
                             IF( DESREF(H2;0;-1)>=400 ; "Medium" ; "Normal ) )

Answer 2

Assuming you're evaluating cell A1, type in the following formula and it will work for your conditions:

=IF(A1>=500,"Critical",IF(A1>=400,"Medium","Normal"))