Values and maxiums

[ben simpson]

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

"ben simpson" <[email protected]> wrote in message
news:[email protected]...
> 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

[gjcase]

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

---Glenn

[gjcase]

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

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

---Glenn

[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))



ben simpson wrote:
>
> 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

--

Dave Peterson

[ben simpson]

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

"Dave Peterson" wrote:

> 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))
>
>
>
> ben simpson wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>