I have been working with a spreadsheet that has a formula in one of the
cells. The formula is not working correctly now and I can't figure out why.
The formula was written by someone who is nolonger here. Could someone please
decipher this for me:

=+IF(L3="U",VLOOKUP(M3,TABLE!$A$1:$L$154,2,0),(IF( NOT(L3="M"),(IF((IF((IF(MIN(BS3:CD3)<=0,"",MIN(BS3 :CD3)))="","",(DAYS360(M3,(IF(MIN(BS3:CD3)<=0,"",M IN(BS3:CD3))),30)/30)))TABLE!$O$3,"",IF(MIN(BS3:CD3)<=0,"",MIN(BS3: CD3)))),VLOOKUP(M3,TABLE!$A$1:$B$167,2,0))))

I am currently using Excel 2000

Many Thanks,

Tonya Boyd

you may have a partial response
if L3= "U"
,VLOOKUP(M3,TABLE!$A$1:$B$154,2,0),if(L3="M",VLOOK UP(M3,TABLE!$A$1:$B$167,2,0),if(or(min(BS3:CD3)<=0 ,Days360(M3,min(BS3:CD3),1)/30TABLE!$O$3,"",MIN(BS3:CD3)

if L3 is "U" and M3 is not to be found in A1:A154 the result will Be #NA
otherwise the value is column B
if L3 is "M" and M# is not to be found in A!:A167 the result will be #NA
other wise the value is column B
For other L3s
if min(BS3:CD3)<=0 the result will be ""
if Days360 (european style) between M3 and the min(BS3:CD3)/30 is less than
O3 in the table sheet the result will be ""
other wise the result will be the min(BS3:CD3)

Two oddities.
the different lookup table sizes in for L3 = "U" versus "M" they may need to
be the same

the other oddity the 30 as the third entry in the day360 formula this
position needs a true or false but will accept a 0 or non zero response the
30 is treated as a true.

What is the problem you are having?


"Tonya B." wrote:

I have been working with a spreadsheet that has a formula in one of the
cells. The formula is not working correctly now and I can't figure out why.
The formula was written by someone who is nolonger here. Could someone please
decipher this for me:

=+IF(L3="U",VLOOKUP(M3,TABLE!$A$1:$L$154,2,0),(IF( NOT(L3="M"),(IF((IF((IF(MIN(BS3:CD3)<=0,"",MIN(BS3 :CD3)))="","",(DAYS360(M3,(IF(MIN(BS3:CD3)<=0,"",M IN(BS3:CD3))),30)/30)))TABLE!$O$3,"",IF(MIN(BS3:CD3)<=0,"",MIN(BS3: CD3)))),VLOOKUP(M3,TABLE!$A$1:$B$167,2,0))))

I am currently using Excel 2000

Many Thanks,

Tonya Boyd