Problem with If
 

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

Problem with If
 

Try this:

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

Hope this helps.

Pete

On Jan 25, 1:43*pm, Box666 wrote:
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

Problem with If
 

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

"Box666" wrote:

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

Problem with If
 

On 25 Jan, 14:04, FSt1 wrote:
hi
see if this will work for you....
=IF(A5="","",IF(A5<25,"A",IF(A5<35,"B",IF(A535,"C ",""))))
regards
FSt1



"Box666" wrote:
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- Hide quoted text -

- Show quoted text -


Thank you that sorted it.

Bob