turn #value into blank cell

  • Thread starter Thread starter amik
  • Start date Start date
A

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?
 
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
 
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
 
that formula makes them all empty, even when there are numbers present?

That means your numbers aren't numeric numbers but are TEXT numbers.
 
that formula makes them all empty, even when there are numbers present?

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