MythicZohar;196885 Wrote:
I am trying to have excel return a certain value based on a series of
date ranges.
I want the value to return true or a specific number if it returns a
number less than the max, but if greater than a max number for the
period I want it to return only the max number.
An example:
01/01/2008-12/31/2008=3000,
01/01/2009-12/31/2009=3600.
So lets say the persons salary or wage for 2008 was 2888.00, then I
would want the formula to return 2888.00.
But if the salary for 2008 was 3700.00 I would want the value to
return 3000.
Can anyone suggest anything?
Thanks in advance
If your salary is in A1 try =MIN(A1,3000)
--
Pecoflyer
Cheers -
*'Membership is free' (
http://www.thecodecage.com)* & allows file
upload -faster and better answers
*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=54247