Thanks, Joe. It gets very frustrating when we tell the OP how to check
whether the data values are numbers or text but we still get told the wrong
information. Glad that you were able to confirm the diagnosis of which we
had all been pretty sure.
--
David Biddulph

"Joe User" <joeu2004 wrote in message
...
"Missy" wrote:
Yes, just confirmed.

Missy misspoke.

I have seen the workbook, and the root cause of the problem is what we
have been trying to tell her: the lookup table contains number strings
(text), not real number. Consequently, of course, VLOOKUP returns text,
not real numbers.

Moreover, the "lesser%" and "greater%" IF formulas are convoluted. They
work by accident only because of the example "numbers" (text) she is
using, namely "9.6" and "17.6".

I have sent her a corrected workbook. Hopefully that will put these
matters to rest.


----- original message -----

"Missy" wrote in message
...
Yes, just confirmed.

"David Biddulph" wrote:

And have you confirmed that they are all numbers by using =ISTEXT() and
=ISNUMBER(), or do the contents just *look* like numbers?
--
David Biddulph

"Missy" wrote in message
...
And I have verified the sheet % does have all numbers.

"Missy" wrote:

B9 =VLOOKUP($F$4,'%'!A2:B65,2,FALSE)
B10 =VLOOKUP($F$5,'%'!A3:B66,2,FALSE)

"Squeaky" wrote:

Hi Missy,

The error is in the B10 chain. There must be a text reference
somewhere. If
B10 is another formula try multiplying the whole thing by 1 in B10.
If
it
gets the #VALUE error it definitely has a text entry somewhere.
Also,
your
formula in B13 will always result in what is in B10 so having the
formula
makes no sense, unless you typed it wrong in the post.

"Missy" wrote:

A B
12 Lesser %: =IF($B$9<$B$10,$B$9,$B$10)
13 Greater %: =IF($B$9$B$10,$B$10,$B$10)
14 Bilateral Hearing Loss: =(((B12*5)+B13)/6)/100

I get a #VALUE! error in B14. I'm not sure what other
information
you need.
The formula in B14 uses the lesser and greater numbers from two
other
cells/formulas. Any help would be appreciated! Thanks!


.