But I have a list of number where 6 equals 500, 7 equals 600, 8 equals 700,
and so one. (Probably about 20 of them) So I came up with this:

=If(b1=6,"500")

And it works. But the problem is that B1 will change, it could be 7 or 8.
And I want that number to correspond with the correct value. I've tried
separating it with a colon and I've put them in parentheses. And it's not
working.

Any ideas?
--
Bobbie Jo