| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation on a calculated cell
I want to have data validation on a cell containing a formula. Is it
possible to have validation on the results of a formula and how do you do it? Here is what I'm doing: A1 (QTY) A2 (UNIT PRICE) A3 (EXTENDED PRICE) A3 HAS THIS FORMULA =A1*A2 I want to have any value exceeding $5000 in A3 cause a data validation error alert to appear with a message instructing what to do. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| 6 Data Validation lists depending on 1 cell value | Excel Discussion (Misc queries) | |||
| How do I validate data from another validation cell? | Excel Worksheet Functions | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
Threaded Mode
