| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help to validate MULTIPLE numbers in one cell, not just the total
you have to put each individual number in a cell, do your check on those
cells, then sum them in another cell. "amanske" wrote: I enter multiple numbers into one cell and they all have to be negative numbers. I would like an error message to occur when a positive number is added. I tried to validate it, but it only gave an error when the total amount was positive. EX: Cell A1 shows---125 (=-130+5) I want an error message when the +5 was entered |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validate a total of a row | Excel Worksheet Functions | |||
| Transposing Multiple Cell References to Multiple Values (NOT total | Excel Discussion (Misc queries) | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| validate phone numbers etc. | New Users to Excel | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
Threaded Mode
