Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |