|As I said in my previous post, you are using more parentheses than necessary.|
Extra parentheses make the formula harder to read, and as you have seen, harder to write.
These two formulas are equivalent:
Excel does not require parentheses around each IF clause nor around the logical_test.
In other words, there is no need to use parentheses around A1>2, A1>0, etc. nor do you need parentheses around each IF.
Let's look at a simple IF function:
=IF(logical_test, value_if_true, value_if_false)
=IF(A1>1, 1, 0)
The value_if_false is 0. As I'm sure you know, there is no need for parentheses around the 0.
Now, instead of using 0, let's replace the value_if_false with another IF function:
=IF(A1>1, 1, IF(A1<1, 0, ""))
Just like the 0 as the value_if_false did not require parentheses around it, the
IF(A1<1, 0, "")) as the value_if_false does not require parentheses around it.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.