Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for a data entry
i want to make a conditional formula in a cell which i want to enter a value
in the same cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for a data entry
"kufo79" wrote:
i want to make a conditional formula in a cell which i want to enter a value in the same cell See an illustration using data validation in the response to your later post -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for a data entry
thank you max for ur help but the link is blocked,
please advice "Max" wrote: "kufo79" wrote: i want to make a conditional formula in a cell which i want to enter a value in the same cell See an illustration using data validation in the response to your later post -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for a data entry
"kufo79" wrote:
thank you max for ur help but the link is blocked, please advice Do you mean my archives link (in sign-off): http://savefile.com/projects/236895 (sometimes savefile.com may be down, just try again later) Or, do you mean the response posted to your later post: Anyway, here's what I posted: 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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
formula references change when data entry sheet is modified | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |