| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i validate a cell that has a formula
HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i validate a cell that has a formula
Place your validation on C2 and C3 with a custom validation where the formula
is =$C$2+$C$3<=1500 -- HTH... Jim Thomlinson "wAYNE" wrote: HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5 CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i validate a cell that has a formula
Also C2 and C3 have formulas is there anyway validation can be used on G5 if
theres a formula in it? "Jim Thomlinson" wrote: Place your validation on C2 and C3 with a custom validation where the formula is =$C$2+$C$3<=1500 -- HTH... Jim Thomlinson "wAYNE" wrote: HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5 CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i validate a cell that has a formula
Validation must be on the precidents of the formula and not on the formula
itself. Go to the precidents of the formula in C2 and C3 and validate on those... -- HTH... Jim Thomlinson "wAYNE" wrote: Also C2 and C3 have formulas is there anyway validation can be used on G5 if theres a formula in it? "Jim Thomlinson" wrote: Place your validation on C2 and C3 with a custom validation where the formula is =$C$2+$C$3<=1500 -- HTH... Jim Thomlinson "wAYNE" wrote: HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5 CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i validate a cell that has a formula
wAYNE -
=IF(C2+C3 1500,"OVER LIMIT!",C2+C3) You could also add conditional formatting. -- Daryl S "wAYNE" wrote: HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5 CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validate entry based on another cell value | Excel Discussion (Misc queries) | |||
| Validate if cell use data validation | Excel Discussion (Misc queries) | |||
| Can I validate a cell only if a certain condition is met? | Excel Discussion (Misc queries) | |||
| Validate a formula NOT a value | Excel Discussion (Misc queries) | |||
| how do I validate the value and not the formula in excel? | Excel Worksheet Functions | |||
Hybrid Mode
