turing #value into a blank cell

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

 

[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.
:

 

[Mike Mueller]

I am sure the Excel NG can teach you all about Conditional Formatting