Help to validate MULTIPLE numbers in one cell, not just the total

A

amanske

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
 
D

dlw

you have to put each individual number in a cell, do your check on those
cells, then sum them in another cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to validate characters within a string of data in aparticular cell 1
How to change positive values in a cell to negative in Excel 2000 7
Sorting pos. & neg. numbers in a cell 1
Two formulas in on cell based on two numbers in another cell? 5
Adding numbers in one cell and showing total in seperate cell 12
Transposing Multiple Cell References to Multiple Values (NOT total 7
Help understanding CSE results 5
Adding multiple numbers in one cell 16

Top