I want to accept one value only or error out cell

  • Thread starter Thread starter jerminski73
  • Start date Start date
J

jerminski73

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
 
I'm sorry, I guess I forgot to include one portion of this cell configuration,
I need the actual value that is inserted in each of those cells, if more
than one cell has a value then I need the error.. It worked the way you have
it but does not pass on the cell value. Thanks again
 
=IF(COUNTBLANK(BA16:BH16)<7,"ERROR
MESSAGE",B116&BB16&BC16&BD16&BE16&BF16&BG16&BH16)

mind the text wrapping!
 
Back
Top