Problem with If

  • Thread starter Thread starter Box666
  • Start date Start date
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
 
Try this:

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

Hope this helps.

Pete
 
hi
see if this will work for you....
=IF(A5="","",IF(A5<25,"A",IF(A5<35,"B",IF(A5>35,"C",""))))
regards
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










- Show quoted text -
Click to expand...


Thank you that sorted it.

Bob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross Referencing two data worksheets and desciphering differences 1
Import Data from the Same Workbook 1
lookup 3
Using result from or funtcion in if statement 2
formula returns the formula 2
Macro Help for a BIG Calculation 1
Check to see if a range name exists on a sheet 2
convert text into Formula 3

Back
Top