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

I want to accept one value only or error out cell
 

=IF(COUNTBLANK(BA16:BH16)<7,"ERROR MESSAGE","")
--
Gary''s Student - gsnu200759

I want to accept one value only or error out cell
 

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

I want to accept one value only or error out cell
 

=IF(COUNTBLANK(BA16:BH16)<7,"ERROR
MESSAGE",B116&BB16&BC16&BD16&BE16&BF16&BG16&BH16)

mind the text wrapping!
--
Gary''s Student - gsnu200759


"jerminski73" wrote:

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

I want to accept one value only or error out cell
 

AWESOME, THANK YOU