If function and text

  • Thread starter Thread starter Katie
  • Start date Start date
K

Katie

I have a list of names and I want to use the IF function
to sort them into categories... for instance if I have a
student database and I all names A-D to say Day 1, E-K to
say Day 2... etc.

The If function seems to only accept numeric tests only?
 
Hi Katie
When using text in an IF function make sure the text is in
inverted commas.
Regards
Michael
 
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

Set non-continuous PrintArea via Function / Name 0
Multiple logic tests 0
IF function 4
Text Function 1
16 diffetent if functions for 2 criteria 4
Referencing text from another cell for criteria in functions 1
If function help 0
Need RANK Function for Text 4

Back
Top