| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values and maxiums
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Values and maxiums
Hi!
What does "accumulated" mean? Biff "ben simpson" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Values and maxiums
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Values and maxiums
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Values and maxiums
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 ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=523300 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Values and maxiums
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 -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=523300 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
