Formula Help

  • Thread starter Thread starter pritesh01
  • Start date Start date
P

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.
 
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:
 
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
 
Back
Top