Thread
:
Turning #value into a blank cell
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
amik
external usenet poster
Posts: 15
Turning #value into a blank cell
I have this formula A5/b5-1
Somtimes due to a pivot table there will be no numbers in the A5 and B5.
Curently it gives mea #value. is there a way to get this to be blank?
I would appreciate any help
Reply With Quote
amik
View Public Profile
Find all posts by amik