| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
