Re: 6.00 to this 0600 please

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try...

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

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

Hope this helps!

In article <3E30D580-1965-4927-8833-37080EE4452B@xxxxxxxxxxxxx>,
Steved <Steved@xxxxxxxxxxxxxxxxxxxxxxxxx> 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.
.