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 change so that ( . . . )/3 and so on.
12 Replies
Not sure I understood the question, especially what "so on" exactly means. As variant
=( A1+2*B1+C1 ) / (IF( A1=97, 3, 4) )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?
