Help on Formula
 

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

Help on Formula
 

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

Help on Formula
 

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

Help on Formula
 

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