Thread: help please
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kara Kara is offline
external usenet poster
 
Posts: 23
Default help please

I need to create a function that will display an error if the sum of a range
of cells subtracted from another cell does not equal 0. I figure the first
part is
=SUM((J12:M12)-I12) that should total 0 and if it does not I need error to
be shown. Any advice/help greatly appreciated