Update - its ok, I found a fault with formula. However, if anybody can find
a smarter way to do this, id be grateful.

Im thinking a vlookup with a range?

i.e. if cell A1 = 57
do a vlookup on 57
in a lookup table that says 1-50 = Rob, 51 - 90 = Dennis
and return the value Rob

--
Rob Gaffney


"Gaffnr" wrote:

Hi All,

Im using a nested if statement to age documents based upon the number of
days old a document is. Ive been using this formula for months and today
the business has decided to change the age buckets so ive simply added more
nested ifs to my formula. However, the cell displays the formula and not the
result whereas before it used to display the reult. All I have done is click
in cell, press F2 and edited formula. Is there a maximum number of nested
if's?

My formula is below

=IF(K3<31,"0 to 30 Days",IF(K3<61,"31 to 60 Days",IF(K3<91,"61 to 90
Days",IF(K3<121,"91 to 120 Days",IF(K3<151,"121 to 150 Days",IF(K3<366,"151
to 365 Days","365+Days"))))))


If there is a maximum no. of nests, can anubody think of another way to do
this?
I Can use a vlookup but the number of days old is potentially limitless and
i dont want to create a lookup table that big.
--
Rob Gaffney