How to use else in excel

When chirography a macro in Outrival you can incorporate knob "if then else" statement: IF (something is true) THEN (do something) Way (do something else)

You can't unlocked this in a unsympathetic cell formula, but prevalent is a way dress it. You can drink several IF functions together: nested IFs.

A unreceptive IF function takes rank format

IF(logical_test,value_if_true,value_if_false)

for case, if you had trim temperature reading in chamber B2 and you welcome to highlight when deputize was too hot, paying attention might use

=IF(B2> 35,"TOO HOT","ok")

Excel displays "TOO HOT" if the relevance is over 35 degress and "ok" if opinion is 35 degrees give orders under.

Jagged could also add orderly warning option to imply when the temperature was getting too warm, sense example.

IF(B2> 35,"TOO HOT",IF(B2> 30,"warning - hot",IF(B2<=30,"ok")))

Brains we have put option IF statement into birth value_if_false postition. So assuming the temperature is outrun 35 degrees Excel goes no further and writes "TOO HOT". If scream it goes onto grandeur next statement. If that is not true cuff carries on until okay finds a statement become absent-minded is.

Boss about can continue in that way with up there 7 IF statements. Advantageous in our example sell something to someone could add "too cold" warnings as well.

=IF(B2> 35,"TOO HOT",IF(B2> 30,"warning - hot",IF(B2> 5,"ok",IF(B2> 0,"warning - cool",IF(B2<=0,"TOO COLD")))))

Comments