how can the formulas be used in a more complicated data?

Dipesh

Thank you for your question.

When building models using IF(), it’s common to come upon a second fork in the road when evaluating either the value_if_true or value_if_false arguments.
For example, consider the variation of our formula that outputs a description based on the value in cell A1:
=IF(A1 >= 1000, “Big!”, “Not big”) What if you want to return a different string for values greater than, say, 10,000? In other words, if the condition A1 > 1000 proves to be true, you want to run another test that checks to see if A1 > 10000. You can handle this scenario by nesting a second IF() function inside the first as the value_if_true argument:
=IF(A1 >= 1000, IF(A1 >= 10000, “Really big!!”, “Big!”), “Not big”) If A1 > 1000 returns TRUE, the formula evaluates the nested IF(), which returns Really big!! if A1 > 10000 is TRUE, and returns Big! if it’s FALSE; if A1 > 1000 returns FALSE, the
formula returns Not big. Note, too, that you can nest the IF() function in the value_if_false argument. For example,
if you want to return the description Small for a cell value less than 100, you would use this version of the formula:
=IF(A1 >= 1000, “Big!”, IF(A1 < 100, “Small”, “Not big”))

I hope this goes some way to answering your question.

regards

Best team