|It is impossible for us to answer your question without more specifics. Let's look at the example question that you asked:|
e.g. we build =sum(if....., can we do =if(sum.....or we have to keep sum at the first position only ?
Here are 2 examples using both methods, showing that it all depends on what you want to do. I'm sure you know this, but I post them just to make a point.
This formula will SUM the results of the 2 IF functions:
This formula will return either Yes or No, depending on the SUM of A1 and B1:
In other words, =SUM(IF... is valid and so is =IF(SUM... but you will obviously get different results because the formulas will be used to accomplish different tasks. That's why we need more information beyond just "we build =sum(if....., can we do =if(sum.....?"
In general, as can be seen when using the Formula Evaluator, Excel will step through the formula from left to right, evaluating each term one by one. If any of the terms return an error, the entire formula will return that error. If different terms return different errors, such as once term returning #VALUE and another returning #NAME, the first error encountered is typically what will be returned.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.