this is an example:

a1 is the cell which i want to enter a value, and i want to make a condition
on it, i mean if a1<0 then a1=0

please advice and thank you

"Toppers" wrote:

Give an example of what you want.

"kufo79" wrote:

thanks max but this is not my question, i want to make another value in the
wanted cell which has a condition

please advice


"Max" wrote:

"kufo79" wrote:
i want to make a conditional formula for a data entry in the same cell

Perhaps an illustration? Suppose data is to be entered in col A, from A1
down, and we want to ensure that only numbers greater than 10 are entered.
Here's what we could do:

Select col A (A1 active)
Click Data Validation
Under Allow: choose Custom
Formula: =AND(ISNUMBER(A1),A110)
Click OK

Now we could test it out by trying various inputs within any cell in col A.
If we enter say in A2: 2, we'd get the error msg. If we enter 20, it gets
accepted OK. If we enter any text, say: Yes, we'd get the error msg, too. And
so on.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---