Thanks, Dave!

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Dave Peterson" wrote in message
...
Typo alert...

USNUMBER()
should be:
IsNumber()




Niek Otten wrote:

Probably not all C cells are numbers, although they may look like
numbers.
You can test this using the USNUMBER() function and you can correct it:
Format a blank cell as Number. Enter 1. EditCopy. Select your C cells.
Edit, Paste Special, check Multiply. OK.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"dmbRedGetta" wrote in message
...
Hey all,

I have an assignment I'm working on for school and I have a formula
using
VLOOKUP. In the assignment, we're looking up a discount rate based on
the
customer's credit score. The credit scores are in the first column and
the
discount rates are in the next four columns (the region number - 109
yields a
column number of 2 through 5, which explains the $D22-109 part of the
formula). Here is the formula:

=ROUND(IF($C22=0,0,((VLOOKUP($C22,$A$7:$E$13,$D22-109,TRUE))*$D$16)*$E22),
2)

I've gotten it to work using "487" instead of the $C22, so I thought
maybe
the type of data in the cell would make a difference, but that doesn't
seem
to change anything. All cells are numbers, so I thought it should
work.
There is no difference (that I can see) from the rows that work and the
rows
that don't. Any ideas would be greatly appreciated!

--

Dave Peterson