Home |
Search |
Today's Posts |
#1
|
|||
|
|||
6.00 to this 0600 please
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. |
#2
|
|||
|
|||
Try...
=(INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<"" ,0))+12)*100 ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , Steved 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. |
#3
|
|||
|
|||
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 , Steved 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formula 0600 = 11:00AM | Excel Discussion (Misc queries) |