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
|