Help on Formula

  • Thread starter Thread starter Srini
  • Start date Start date
S

Srini

Someone please help me with a formula. I've data in A,B,C columns and need
grades in Column 'E'.

A B C E
70.77 26.69 18.00 C
78.83 75.61 70.01 A
56.24 27.02 70.00 C
89.96 57.27 B

I need a formula that gives grade "A" if all values in row is above 70 and
"B" if any one of them is below 70 and above 50 and "C" if any one of them is
below 50.

Thanks for you help in advance...
 
Dear Srini

Try and feedback ...

=IF(COUNT(A1:C1)=0,"",IF(COUNTIF(A1:C1,">70")=COUNT(A1:C1),"A",IF(AND(COUNTIF(A1:C1,"<50")>0,COUNT(A1:C1)>0),"C","B")))

If this post helps click Yes
 
Dear Srini

Try and feedback ...

=IF(COUNT(A1:C1)=0,"",IF(COUNTIF(A1:C1,">70")=COUNT(A1:C1),"A",IF(AND(COUNTIF(A1:C1,"<50")>0,COUNT(A1:C1)>0),"C","B")))

If this post helps click Yes
 
AND condition in previous formula avoided...

=IF(COUNT(A1:C1)=0,"",IF(COUNTIF(A1:C1,">70")=COUNT(A1:C1),"A",IF(COUNTIF(A1:C1,"<50")>0,"C","B")))

If this post helps click Yes
 
AND condition in previous formula avoided...

=IF(COUNT(A1:C1)=0,"",IF(COUNTIF(A1:C1,">70")=COUNT(A1:C1),"A",IF(COUNTIF(A1:C1,"<50")>0,"C","B")))

If this post helps click Yes
 
Thanks Jacob, It works great..
--
Srini....


Jacob Skaria said:
AND condition in previous formula avoided...

=IF(COUNT(A1:C1)=0,"",IF(COUNTIF(A1:C1,">70")=COUNT(A1:C1),"A",IF(COUNTIF(A1:C1,"<50")>0,"C","B")))

If this post helps click Yes
Click to expand...
 
Thanks Jacob, It works great..
--
Srini....


Jacob Skaria said:
AND condition in previous formula avoided...

=IF(COUNT(A1:C1)=0,"",IF(COUNTIF(A1:C1,">70")=COUNT(A1:C1),"A",IF(COUNTIF(A1:C1,"<50")>0,"C","B")))

If this post helps click Yes
Click to expand...
 
Back
Top