6.00 to this 0600 please

S

Steved

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.
 
D

Domenic

Try...

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

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

Hope this helps!
 
S

Steved

Excellent and thankyou very much.

Domenic said:
Try...

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

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

Hope this helps!
Click to expand...
 
Top