You had <10 when I assume you meant >10 and >3 when I assume you meant <3, based on the labels you provided. Here's a calc:
If [field] > 10 Then ">10 Days Wait"
Elseif [field] > 3 Then "3 - 10 Days Wait"
Elseif [field] > 0 Then "1 - 3 Days Wait"
Elseif [field] = 0 Then "0 Days Wait"
You could change the last Elseif to an Else if you know the only remaining values are 0. When I'm working with data that I don't know I like to be explicit about the values I expect and then leave room in the calculation for unexpected values, for example what would you want to display if there were -1 days? In that case, the calc as I wrote it will return Null and you'll have a chance to see that in your results.
Thanks Jonathan! If a want the Nulls to be a catagory as well would it be...
Elseif "Null" then "No Show"
You wouldn't use quotes around the Null. Quotes around text indicate the value is a string, so "Null" is different from Null.
How would you add the logic for something like
If a negative number then "Error"
If a blank "" then "No Show"
You'd just tack on some more ELSEIF's. One question, though - is the field blank "" or Null? If it's Null, then you don't use =, you use the ISNULL() function, which returns binary True if the field is Null.
ELSEIF [field] <0 THEN "Error"
ELSEIF "" THEN "No Show"
ELSEIF ISNULL([field]) THEN "field is Null"
it's a blank field in excel with no value, so i assume i use the ELSEIF ISNULL([field]) THEN "field is Null"
It's probably Null, you'll have to load your data and find out whether it's really Null or "" (an empty string).