turing #value into a blank cell

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.
 
T

Tom Willett

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
Sumproduct from previously blank row 2
Retrieve cell value basis the inputs into a diff cell // sk. 5
How to Control a formula by a character in adjacent column on same 4

Top