Yeah I am trying to get my formuala to calculate two vlookups....

Is that not possible?

"T. Valko" wrote:

that formula makes them all empty, even when there are numbers present?

That means your numbers aren't numeric numbers but are TEXT numbers.


--
Biff
Microsoft Excel MVP


"amik" wrote in message
...
that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it
displays an
empty cell?