Formula Help

[pritesh01]

I think this may be simple, but im not sure how to do this.
I have about 14 rows, which have values or either 1,2,3 or 4.
I need to be able to write a formula, that would see if the value in
the cell is equal to 1 and print yes in place of 1, no in place of 2,
exempt in place of 3, and other in place of 4.

After doing that...
I need to know how to count by col, number of yes's, number of no's,
number of exempt.

 

[Guest]

You cannot display other value then the content of the cell cell. You can
make a conversion into another cell, say on a separate sheet with this
function (sheet1 beeing your original one):
Type in Sheet2 CellA1
=CHOOSE(Sheet1!A1,"yes","no","exempt","other")

and drag it down to row 14!

Regards,
Stefi

„[email protected]†ezt írta:

 

[Roger Govier]

Hi

You could do without converting the numbers
=COUNTIF(A1:A14,1) for 1, ,2 for 2 etc.
or but the values 1 2 3 4 in B1:E1 then enter in B2
=COUNTIF($A$1:$A$14,B$1)
Copy across through C2:E2

If you did want to change the numerics to text, then enter in B1
=IF(A1="","",IF(A1>4,"",IF(A1=1,"Yes",IF(A1=2,"No",IF(A1=3,"Exempt","Other")))))
and copy down

Put Yes, No, Exempt, Other in C1:F1 and in C2 enter
=COUNTIF($B$1:$B$14,C$1)
and copy across