# formula help !!

#### royhern

##### Board Regular
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

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
if(ab1<=70,"fs",if(and(ab1>=70,ab1<=149),"m","ce"))

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

etc

second 70 should be 71!

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

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

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?

Replies
5
Views
275
Replies
2
Views
210
Replies
4
Views
239
Replies
6
Views
186
Replies
14
Views
401

1,220,965
Messages
6,157,122
Members
451,399
Latest member
alchavar

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back