Help Tidying up formula

Hi,

I'm trying to minimise the size of a file by trimming down the formulae.
Would anybody have any suggestions on the following

=IF($E12="","",IF(Reintype($E12)="Assumed",VLOOKUP($B$6&G12,[Data.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),IF(Reintype($E12)="Ceded",VLOOKUP($B$6&$G12,[Data.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),"")))

(note: "Reintype" is a user define function whcih tests to see if the
content of Exx is within certain ranges of numbers

One suggestion

=IF($E12="","",IF(OR(Reintype($E12)="Assumed",Reintype($E12)="Ceded"),VLOOKU
P($B$6&$G12,[Data.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Paul" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm trying to minimise the size of a file by trimming down the formulae.
> Would anybody have any suggestions on the following
>
>
=IF($E12="","",IF(Reintype($E12)="Assumed",VLOOKUP($B$6&G12,[Data.xls]DECAP_
ALL2!A:W,17+($I12-1),FALSE),IF(Reintype($E12)="Ceded",VLOOKUP($B$6&$G12,[Dat
a.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),"")))
>
> (note: "Reintype" is a user define function whcih tests to see if the
> content of Exx is within certain ranges of numbers

"Bob Phillips" wrote:

> One suggestion
>
> =IF($E12="","",IF(OR(Reintype($E12)="Assumed",Reintype($E12)="Ceded"),VLOOKU
> P($B$6&$G12,[Data.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),""))
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Paul" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I'm trying to minimise the size of a file by trimming down the formulae.
> > Would anybody have any suggestions on the following
> >
> >
> =IF($E12="","",IF(Reintype($E12)="Assumed",VLOOKUP($B$6&G12,[Data.xls]DECAP_
> ALL2!A:W,17+($I12-1),FALSE),IF(Reintype($E12)="Ceded",VLOOKUP($B$6&$G12,[Dat
> a.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),"")))
> >
> > (note: "Reintype" is a user define function whcih tests to see if the
> > content of Exx is within certain ranges of numbers
>
>
>

Thanks for the reply Bob. I made a mistake in the formula though so I'll try
that again. The difference is depending on whether the result is Assumed or
Ceded there is a different lookup reference i.e. if assumed return index 15,
if Ceded return index 17+($I12-1)

The formula should have read:

=IF($E12="","",IF(Reintype($E12)="Assumed",VLOOKUP($B$6&G12,[Data.xls]DECAP_ALL2!A:W,15,FALSE),IF(Reintype($E12)="Ceded",VLOOKUP($B$6&$G12,[Data.xls]DECAP_ALL2!A:W,17+($I12-1),FALSE),"")))

Thanks Again

Paul,
if the only options fo Reintype(E12) are blank, "Assumed" and "Ceded"
then the following should do.

=3DIF($E12=3D"","", VLOOKUP($B$6&G12,[Data.xls]DECAP=AD_ALL2!A:W,
IF(Reintype($E12)=3D"Assumed", 15, 17+($I12-1)), FALSE))

HTH
Kostis Vezerides