Help on Formula

[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...

 

[Jacob Skaria]

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

 

[Jacob Skaria]

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

 

[Jacob Skaria]

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

 

[Jacob Skaria]

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

 

[Srini]

Thanks Jacob, It works great..
--
Srini....

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

 

[Srini]

Thanks Jacob, It works great..
--
Srini....

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