|You didn't say where your "value" was, so I assumed everything is in Row 1, with your "value" in D1.|
An IF statement has this syntax:
=IF(logical_test, value_if_true, value_if_false)
A Nested IF is an IF statement where the value_if_false is another IF statement:
=IF(logical_test, value_if_true, IF(logical_test, value_if_true, value_if_false), etc.)
An AND statement compares multiple arguments and returns TRUE only when all arguments are TRUE.
Combining the AND statements with a Nested IF, we get this:
Note that we don't need to check for D1>C1 (400) because the only way we get that far is if everything before that is FALSE. An IF stops checking when a value_if_true is returned so the formula above will only return 400 if everything before it FALSE.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.