View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jerminski73 jerminski73 is offline
external usenet poster
 
Posts: 41
Default I want to accept one value only or error out cell

I have cells BA16:BH16 calculating value based on certain criteria, it all
calculates correctly, I want to get an error message if more than one of
these cells contains a value. Ideas?

Thanks, J