Search results for query: *

Thank you so much! I was leaving out the extra parentheses.

When I add "else" I get the error "The formula result must be a number".

Well I was able to do the first number, but when I try to do the next number, I get the error "The remaining text does not appear to be a part of the formula". I guess now my question is how do I list all of them? Or do I have to create a separate formula for each number?

I work in Records Management and am creating a report that shows the statuses of all of our current destruction batches. For some reason though, each status is presented as numbers. So it shows batch A as "1". 1 actually means "Batch Created". Then Batch B is shown as "2" which means...

I'm trying to create a formula so that 1 equals a set of words, 2 equals a different set of words, 3 equals another set of words, etc. I tried using an If Then Else function but keep getting an error. I can't seem to find anything else close to what I'm needing. Someone please help me!!