6.00 to this 0600 please

Try...

=(INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0))+12)*100

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article <[email protected]>,
Steved <[email protected]> wrote:

> Hello from Steved
>
> I have 2 columns one with
> =INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0)) and the second with
> =(D2+12)*100
>
> Please can i combine the above formula.
>
> Ok the first column brings in 1.00 the second column changes it to 1300
> so instead of creating another column just have the one column with 1300 in
> it
> Thankyou.

Excellent and thankyou very much.

"Domenic" wrote:

> Try...
>
> =(INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0))+12)*100
>
> ....confirmed with CONTROL+SHIFT+ENTER.
>
> Hope this helps!
>
> In article <[email protected]>,
> Steved <[email protected]> wrote:
>
> > Hello from Steved
> >
> > I have 2 columns one with
> > =INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0)) and the second with
> > =(D2+12)*100
> >
> > Please can i combine the above formula.
> >
> > Ok the first column brings in 1.00 the second column changes it to 1300
> > so instead of creating another column just have the one column with 1300 in
> > it
> > Thankyou.
>

Hello from Steved

I have 2 columns one with
=INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0)) and the second with
=(D2+12)*100

Please can i combine the above formula.

Ok the first column brings in 1.00 the second column changes it to 1300
so instead of creating another column just have the one column with 1300 in
it
Thankyou.

Try...

=(INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0))+12)*100

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article <[email protected]>,
Steved <[email protected]> wrote:

> Hello from Steved
>
> I have 2 columns one with
> =INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0)) and the second with
> =(D2+12)*100
>
> Please can i combine the above formula.
>
> Ok the first column brings in 1.00 the second column changes it to 1300
> so instead of creating another column just have the one column with 1300 in
> it
> Thankyou.

Excellent and thankyou very much.

"Domenic" wrote:

> Try...
>
> =(INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0))+12)*100
>
> ....confirmed with CONTROL+SHIFT+ENTER.
>
> Hope this helps!
>
> In article <[email protected]>,
> Steved <[email protected]> wrote:
>
> > Hello from Steved
> >
> > I have 2 columns one with
> > =INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<>"",0)) and the second with
> > =(D2+12)*100
> >
> > Please can i combine the above formula.
> >
> > Ok the first column brings in 1.00 the second column changes it to 1300
> > so instead of creating another column just have the one column with 1300 in
> > it
> > Thankyou.
>