Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in excel
i want to make a conditional formula for a data entry in the same cell
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in excel
"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 --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in ex
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 --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in ex
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 --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in ex
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 --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in ex
hi Mr. Toppers you didn't find the solution of my problem yet, plz inform
"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 --- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in ex
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. "kufo79" wrote: hi Mr. Toppers you didn't find the solution of my problem yet, plz inform "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 --- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to make a formula for a data entry in the same cell in ex
ok thank you Mr. Toppers for your time
"Toppers" wrote: 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. "kufo79" wrote: hi Mr. Toppers you didn't find the solution of my problem yet, plz inform "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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula timestamp for a data entry of a referenced cell | Excel Worksheet Functions | |||
how to make excel record cell entry dates | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How do you write an excel formula to sum data in every second cell | Excel Worksheet Functions | |||
How do I make all data in the formula bar appear in the cell | Excel Worksheet Functions |