| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to accept one value only or error out cell
=IF(COUNTBLANK(BA16:BH16)<7,"ERROR MESSAGE","")
-- Gary''s Student - gsnu200759 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to accept one value only or error out cell
AWESOME, THANK YOU
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell will not accept data | Excel Discussion (Misc queries) | |||
| Set cell to only accept 1 character | Setting up and Configuration of Excel | |||
| Can a cell be set to accept input only once? | Excel Worksheet Functions | |||
| Why won't cell accept any formula ? | Excel Discussion (Misc queries) | |||
| Cell to accept checkmark or "x" | New Users to Excel | |||
Linear Mode
