Forum Discussion
Excel calculate
I want to calculate the numbers 0 - 20 based on the formula (a1+2*b1+c1)/4. maybe the number 97 is one of the scores. in this case 97 must not calculate. if 97 is in the a1 column, the formula must c...
Hi Mr.Baklan
I tried your formula. When numbers were 0-20, worked correctly not with 97.
I mean, when 97 is in column A1, for example: ( 97 ,17, 19)/3, in column B1,(18, 97, 20)/2 and in column C1 ( 16, 17.5, 97)/3.
Sorry, I didn't catch. If take your text literally that is
What and where is located exactly?
- I apologize you.
Row not column.
First row is( 97 , 17 ,19)/3
Second row (19, 97,20)/2
And third row ( 16 , 17.5,97)/3
Number 97 must not calculate.So, that's like
Result shall be in D1, D2 and D3. It is calculated as =(A1+2*B1+C1)/n. If any of A1, B1, C1 is equal to 97 we consider it as zero, correct?
And what is the logic with n, why it is 3 for the first row, 2 for second and 3 for third?
- 97=0? No
Consider each row has 2 scores not 3.
When we don't consider 97, that is, the all rows have 2 scores.The first row has 2 scores and the average is( 2*17+19)/3