turn #value into blank cell

[amik]

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?

 

[Jacob Skaria]

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")

 

[Jacob Skaria]

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")

 

[Eduardo]

Hi, use

=iferror( (A5/B5)-1,"")

 

[Eduardo]

Hi, use

=iferror( (A5/B5)-1,"")

 

[amik]

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

any advice?

 

[amik]

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

any advice?

 

[amik]

That gives me a #name....

Hi, use

=iferror( (A5/B5)-1,"")

 

[amik]

That gives me a #name....

Hi, use

=iferror( (A5/B5)-1,"")

 

[Eduardo]

OPPss, there was an extra space

=iferror((A5/B5)-1,"")

 

[Eduardo]

OPPss, there was an extra space

=iferror((A5/B5)-1,"")

 

[Jacob Skaria]

The formula works only if there are 2 values; or otherwise return blank. Are
you trying the range A5:B5 itself.

If this post helps click Yes

 

[Jacob Skaria]

The formula works only if there are 2 values; or otherwise return blank. Are
you trying the range A5:B5 itself.

If this post helps click Yes

 

[T. Valko]

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

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

 

[T. Valko]

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

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

 

[amik]

for some reason it is still giving me an # name statement...

 

[amik]

for some reason it is still giving me an # name statement...

 

[amik]

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

Is that not possible?

 

[amik]

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

Is that not possible?

 

[Jacob Skaria]

=IF(COUNT(INT(A5),INT(B5))=2,(A5/B5)-1,"")