formula help !!

royhern

Board Regular
Joined
Feb 21, 2002
Messages
158
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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
if(ab1<=70,"fs",if(and(ab1>=70,ab1<=149),"m","ce"))

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

etc
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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

Board Regular
Joined
Feb 21, 2002
Messages
158
Using countif it is possible to count only those answers that are in the visible rows?
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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?
 

Forum statistics

Threads
1,144,208
Messages
5,723,020
Members
422,475
Latest member
Lawiltshire

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top