turing #value into a blank cell

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

amik

I am using the formula
(A5/B5)-1 is there a way to format that so that if A5 and B5 are empty
it will display a blank cell?


Any help would be great.
 
Not in FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
:I am using the formula
: (A5/B5)-1 is there a way to format that so that if A5 and B5 are empty
: it will display a blank cell?
:
:
: Any help would be great.
:
 

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

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
turn #value into blank cell 30
Turning #value into a blank cell 3
HELP please... easy function 2
result should equal a blank field 2
Hide columns based on row values 2
Comparison of columns using Conditional Formatting 3
Excel function - countif 2

Back
Top