turn #value into blank cell
Oops...
=IF(ISERROR(A5/B5),"",(A5/B5)-1)
--
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
=IF(COUNT(INT(A5),INT(B5))=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria
"amik" wrote:
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?
|