how do i validate a cell that has a formula
in [General]
|
From: wAYNE on 1 Mar 2010 12:12 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
From: Jim Thomlinson on 1 Mar 2010 12:26 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
From: wAYNE on 1 Mar 2010 13:10 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
From: Daryl S on 1 Mar 2010 13:31 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
From: Jim Thomlinson on 1 Mar 2010 14:13 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
|
Pages: 1 Prev: Linking option buttons and returning data across worksheets Next: validate |