Even when excel has a lot probably hundreds of built in functions like sum vlookup left and so on once you start using excel for more complicated tasks you will often find. Now we have to use the nested IF formulas as we have used in the above example to calculate the Grade for the product quality. Modify simply start defining at the top ie.
IF B280AIF B270BIF B260CD The logic that we have defined in this case is as below.
We will add a formula into cell C3 to calculate the sum of cells A1 and B2. Use IF when you need to formulate evaluate the result and when the grades are more than 7 15 you may have to write many nested ifs N-1 this makes the formula longer and complex You need to use Comparison operators in the test conditions. So for each cell in the Total column we will enter SUMGrade Cell Weight Cell so my first formula is SUM B2C2 the next one would be SUM B3C3 and so on. Calculate The ifs or bins are limited so calculation speed isnt a factor.