Thread: error message "#VALUE!" due to blank cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default error message "#VALUE!" due to blank cells
Hi

Try this

=IF(A1="","",B1-A1)

change ranges to suit

HTH
Mick.
Reply With QuoteReply With Quote