how do i validate a cell that has a formula

W

wAYNE

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
 
J

Jim Thomlinson

Place your validation on C2 and C3 with a custom validation where the formula
is
=$C$2+$C$3<=1500
 
W

wAYNE

Also C2 and C3 have formulas is there anyway validation can be used on G5 if
theres a formula in it?
 
D

Daryl S

wAYNE -

=IF(C2+C3 > 1500,"OVER LIMIT!",C2+C3)

You could also add conditional formatting.
 
J

Jim Thomlinson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

validate 1
I Need an answer for this Formula 2
Copy addition formula of non-consecutive horizontal cells 2
2007 conditional formatting not playing ball 5
Using IF, AND and OR functions together 2
IF Statement accepting only positive values 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
problem with formulas (2) 7

Top