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
|