Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |