| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DATA VALIDATION - for data which is the result of a formula
Can this be done? If so, how?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DATA VALIDATION - for data which is the result of a formula
No, data validation only pertains to entering the data in the cell.
You would probably need to use the calculate event or further explain what causes the value of the cell to change. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Can this be done? If so, how? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DATA VALIDATION - for data which is the result of a formula
Here's the formula in the cell - it derives from entries of hours worked:
=IF(AND(U20=0,(F20+J20+M20)<9.5),10-(F20+J20+M20)-S20,0) "Tom Ogilvy" wrote: No, data validation only pertains to entering the data in the cell. You would probably need to use the calculate event or further explain what causes the value of the cell to change. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Can this be done? If so, how? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DATA VALIDATION - for data which is the result of a formula
so if the user is entering data in F20, J20, M20 or U20, then you could use
a change event to validate their entry or use data validation on those cells. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Here's the formula in the cell - it derives from entries of hours worked: =IF(AND(U20=0,(F20+J20+M20)<9.5),10-(F20+J20+M20)-S20,0) "Tom Ogilvy" wrote: No, data validation only pertains to entering the data in the cell. You would probably need to use the calculate event or further explain what causes the value of the cell to change. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Can this be done? If so, how? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DATA VALIDATION - for data which is the result of a formula
the user enters only in J 20 and M20. F20 and U20 are formulas. Guess I
need to read up on "calculate event" - which is a new one on me. Thanx Tom "Tom Ogilvy" wrote: so if the user is entering data in F20, J20, M20 or U20, then you could use a change event to validate their entry or use data validation on those cells. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Here's the formula in the cell - it derives from entries of hours worked: =IF(AND(U20=0,(F20+J20+M20)<9.5),10-(F20+J20+M20)-S20,0) "Tom Ogilvy" wrote: No, data validation only pertains to entering the data in the cell. You would probably need to use the calculate event or further explain what causes the value of the cell to change. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Can this be done? If so, how? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DATA VALIDATION - for data which is the result of a formula
If you just want to validate the entries in J20 and M20, then you can do
that with data validation or use the Change event. For a general discussion of events see Chip Pearson's page on this topic http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... the user enters only in J 20 and M20. F20 and U20 are formulas. Guess I need to read up on "calculate event" - which is a new one on me. Thanx Tom "Tom Ogilvy" wrote: so if the user is entering data in F20, J20, M20 or U20, then you could use a change event to validate their entry or use data validation on those cells. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Here's the formula in the cell - it derives from entries of hours worked: =IF(AND(U20=0,(F20+J20+M20)<9.5),10-(F20+J20+M20)-S20,0) "Tom Ogilvy" wrote: No, data validation only pertains to entering the data in the cell. You would probably need to use the calculate event or further explain what causes the value of the cell to change. -- Regards, Tom Ogilvy "Gator Girl" wrote in message ... Can this be done? If so, how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| data validation using formula result | Excel Discussion (Misc queries) | |||
| Using formula result for data series bound | Excel Discussion (Misc queries) | |||
| Need a formula to change data result weekly. | Excel Worksheet Functions | |||
| Replace data with the result of a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
