Thread: #Value Being Returned for Blank or Non Zero Value
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default #Value Being Returned for Blank or Non Zero Value
You're welcome.

Pete

On Nov 12, 6:23 am, "Jack" wrote:

Pete, I modified your formula slightly
=IF(ISERROR(F39*G40),"",(F39*G40))
and got the effect that I wanted. Thanks for your help.


Reply With QuoteReply With Quote