formula help !!

[royhern]

Team, i am looking for two formulas that can do this simple tasks. After all calculations are done a number appears in column AB from top to bottom for every row. This number could be from 150 to 200 which needs to be assigned a letters "CE",71 to 149 which needs to be assigned the letter "M" or if this number is between 0 to 70 needs to be assigend the letters "FS".

What i need is to put in column AC1 the formula that can take a look at number in AB1, determine if base on the number should be assigned CE, M or FS and write it in AC1.

Also at the end of the column i would like a formula that can log how many CE, M and FS were listed.

Hey team thanks and this is a great Site for learning !!!

Roy

 

[DonkeyOte]

if(ab1<=70,"fs",if(and(ab1>=70,ab1<=149),"m","ce"))

countif("ac1:ac10000","m")

etc

 

[DonkeyOte]

second 70 should be 71!

 

[Aladin Akyurek]

Also:

In AC1 enter:

=INDEX({"FS","M","CE"},MATCH(AB1,{0,71,150}))
This message was edited by Aladin Akyurek on 2002-09-20 04:56

 

[royhern]

Using countif it is possible to count only those answers that are in the visible rows?

 

[Aladin Akyurek]

On 2002-09-22 04:36, royhern wrote:
Using countif it is possible to count only those answers that are in the visible rows?

I fail to see any relation between your original question and countif plus visible rows. Care to elaborate?