Thread
:
turn #value into blank cell
View Single Post
#
5
Posted to microsoft.public.excel.misc
amik
external usenet poster
Posts: 15
turn #value into blank cell
That gives me a #name....
"Eduardo" wrote:
Hi, use
=iferror( (A5/B5)-1,"")
"amik" wrote:
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?
Reply With Quote
amik
View Public Profile
Find all posts by amik