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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top