You can nest the IF's like
=IF(B1=6,500,IF(B6=7,600)) etc
but you can only nest seven of them. The best way to do this I think is to
use a VLOOKUP table, have a look at VLOOKUP in help,
Regards,
Alan.
"Bobbie Jo" wrote in message
...
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