6.00 to this 0600 please

[Guest]

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.

 

[Domenic]

Try...

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

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

Hope this helps!

 

[Guest]

Excellent and thankyou very much.

Try...

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

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

Hope this helps!