Most valuable professional
  • Hot Topics

Excel function calculation of cells

Hi, I have some calculation cases as follows which is common in primary school lessons. 1 1 ( there are about 64 combinations to calculate the cells. like +++ ++- ++x ++............... I used "nested if" for case 1 like ( =if(and(b1="+",d1="+",f1="+"),a1+c1+e1,"")&if(and(b1="+",d1="+",f1="-"),a1+c1-e1,"")&if(...................................) since there are about 10 cases as above as the brackets position change , and each has about 64 combinations. the formula becomes tremendously cumbersome. Please advise how to shorten the nested ifs or create UDF to solve such problems. Thanks

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of March 7, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel