want to make a formula for a data entry in the same cell in excel

M

Max

kufo79 said:
i want to make a conditional formula for a data entry in the same cell
Click to expand...

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),A1>10)
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.
 
K

kufo79

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

please advice
 
T

Toppers

Give an example of what you want.

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

please advice
Click to expand...
 
K

kufo79

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
 
T

Toppers

You cannot enter a value in the same cell that you have a formula.

You could use Data Validation to set a minimum value of 0 and a maximum of
whatever

HTH.
 
K

kufo79

ok thank you Mr. Toppers for your time

Toppers said:
You cannot enter a value in the same cell that you have a formula.

You could use Data Validation to set a minimum value of 0 and a maximum of
whatever

HTH.
Click to expand...
 
Top