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


"Jacob Skaria" wrote:

AND condition in previous formula avoided...

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

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Dear Srini

Try and feedback ...

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

If this post helps click Yes
---------------
Jacob Skaria


"Srini" wrote:

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