we combine many formulas in to one for various calculations. is there any fixed criteria whether this formula will added first and another after that ? e.g. we build =sum(if....., can we do =if(sum.....or we have to keep sum at the first position only ? excel does not gives idea for this. when we fill up one formula it is done, no choice for second formula,

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:

=SUM(IF(A1>2,4,0),IF(B1>2,4,0))

This formula will return either Yes or No, depending on the SUM of A1 and B1:

=IF(SUM(A1,B1)>4,"Yes","No")

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.

thanks for the answer ,i got what you mean. can you describe same thing for index,match,vlookup and some other important formulas ?

regards

Once again, I don't know what you are asking for. If you are looking for examples of the many, many, many ways that INDEX, MATCH, VLOOKUP, etc. can be used I suggest you do some simple Web searches and see what other Excel users are doing with those functions.

There are many questions in this forum that I can't answer outright, but after a little time searching the web and reading other questions and answers in other forums, I can usually use the information I find elsewhere to craft a solution to the questions in this forum.

For example, if you want to learn something about INDEX and MATCH, do a search for

VLOOKUP to the left. Since VLOOKUP only looks to the right of the function, you'll find examples of using INDEX and MATCH to look left. The solution to that issue will give you insight into how INDEX and MATCH work.There's a ton of information out there. I learned most of my Excel skills by reading Q&A's in various forums and by using simple search phrases for examples of how various functions can be used.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

thanks you very much

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History