Hi! I am trying to add up the sums of my if then statement outputs.
For example, I was doing a transcript calculator so that
Column 11 = A
Column 21 = if A, then 4.0
Column 12 = B+
Column 22 = if B+, then 3.3
How do I sum up the if then outputs? i.e, 4.0 + 3.3. If I do sum of column 2, the value is 0 and not 4.0+3.3.
Thanks! And I hope this isn’t too confusing!
Sorry for the confusion, I basically used this formula:
=IF(C3="p", "0.0",IF(C3="a","4.0",IF(C3="a-", "3.7",IF(C3="b+", "3.3",IF(C3="b", "3.0", IF(C3="b-", "2.7"))))))
so if the grade is A, then the value is 4.0. If the grade is A-, then the value is 3.7, etc.
Once the cell displayed that information (4.0, 3.7, etc), how do I add it up? When I just do sum of the column, it shows up with a value of 0. Thanks!
Sorry its not understandable yet will attempt to help you
use of switch statement will be nicer in such situations will make clean code.
switch(_case){
case ‘A’: dosomething() ;
case 21:;
case 12:;
case 22:;
}
hope this helps
Cheers:)