Values and maxiums

[Guest]

I'm soooo lost here. I need a way to reference a hire date (E15) , and if
the date is earlier than July 1st ,1989, allow a maxium of 201 to be
accumulated in U35, but, if the hire date is July 1,1989 or later, allow a
maxium of 120 to be accumulated in U35. I believe my brain just
spontaneously cumbusted on this one......Ouch....Help....Ben

 

[Biff]

Hi!

What does "accumulated" mean?

Biff

 

[gjcase]

You can use data validation if the entry is being typed into U35, but i
U35 is a formula, that won't do it..

---Glen

 

[Dave Peterson]

You could use another cell:
=MIN(U35,IF(E15<DATE(1989,7,1),201,120))
or
=MIN(whateverformulawasinU35,IF(E15<DATE(1989,7,1),201,120))

 

[gjcase]

Assuming U35 is a formula summation, how about just using a conditiona
format to color the cell if the value in the cell excceds th
allowable? (alowable can be set via the formula, or calculate
elsewhere with an If statement & then referenced in the conditiona
formula.)

Not as nice as validation, but it would quickly highlight violations.

---Glen

 

[Guest]

Many Thanks Dave. I can work out the rest from here.....Ben