On Tue, 15 Aug 2006 18:40:02 -0700, Bobbie Jo
wrote:

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?

How about using =100*B1-100 or =100*(B1-1)?
--

Cheers . . . JC