Thread: need to substitute formula result from #### to"CHECK YOUR ENTRY"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trevor Trevor is offline
external usenet poster
  
Posts: 31
Default need to substitute formula result from #### to"CHECK YOUR ENTRY"
I have a results cell that adds total time worked minus meal time.
excel displays negative time as ####.
How can I amend the formula to change #### to show "CHECK YOUR ENTRY"
Reply With QuoteReply With Quote