Problem with If

B

Box666

Sorry i do not use excel very often and i cannot recall how to write
the following.

In colA I have a list of numbers as welll as a few blank cells, in
colM I need to break them down.

In simple english I am trying to say if the number in colA is between
1 and 25 put an "A" in colM, if the number is between 26 and 35 put a
"B" in ColM and if it is over 35 put a "C" in colM but if it is blank
then put a blank in ColM.

I thought i had it sorted but the blank cells keep being shown as
either A or C depending on how i write it.

Any help greatfully accepted.

bob
 
P

Pete_UK

Try this:

=IF(OR(A1="",A1<=0),"",IF(A1<=25,"A",IF(A1<=35,"B","C")))

Hope this helps.

Pete
 
F

FSt1

hi
see if this will work for you....
=IF(A5="","",IF(A5<25,"A",IF(A5<35,"B",IF(A5>35,"C",""))))
regards
FSt1
 
B

Box666

hi
see if this will work for you....
=IF(A5="","",IF(A5<25,"A",IF(A5<35,"B",IF(A5>35,"C",""))))
regards
FSt1










- Show quoted text -
Click to expand...


Thank you that sorted it.

Bob
 
Top