Using the IF function
 

Why does this forumla not work? =IF(J2=N14:N26,"A",IF(J2=N27:N40,"B",IF
(J2=N41:N52,"C")))

It needs ot be entered as an array formula, but you also need to tell it
whether you want the J2= to be an "Or" or an "and"
in other words do you want it to have to equal any of the cells or all of
the cells.
if or use
=IF(or(J2=N14:N26),"A",IF(or(J2=N27:N40),"B",IF(or (J2=N41:N52),"C")))
and enter as an array control-shift-enter
for and just repace the ors with ands


"icc56 via OfficeKB.com" wrote:

Why does this forumla not work? =IF(J2=N14:N26,"A",IF(J2=N27:N40,"B",IF
(J2=N41:N52,"C")))

Thank you so much. It still doesn't work for me. I've even changed to =IF
(OR(J2=45-57),"A",IF(OR(J2=31-44),"B",IF(OR(J2=19-30),"C"))) and it still
doesn't work. I want the cell to read "A" if the J2 totals 45-57, etc.

If I am reading this correctly you want The cell to ="A" if J2 is between 45
and 57
try
=if(J257,"",if(J244,"A",if(J230,"B",if(J218,"C "))))
of
if(And(J2<=57,J2=45),"A",if(and(J2<=44,J2=31),"B ",if(and(J2<=30,J2=19),"C","")))

"icc56 via OfficeKB.com" wrote:

Thank you so much. It still doesn't work for me. I've even changed to =IF
(OR(J2=45-57),"A",IF(OR(J2=31-44),"B",IF(OR(J2=19-30),"C"))) and it still
doesn't work. I want the cell to read "A" if the J2 totals 45-57, etc.

Still need help on this one if anyone has any ideas.

--
Message posted via http://www.officekb.com

BJ - thank you! This one works! :)

--
Message posted via http://www.officekb.com

You are a god!

--
Message posted via http://www.officekb.com