If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar view from 10 pm to 06:00 am | laruvv | Calendar | 1 | May 25th, 2005 08:05 AM |
Time formula 0600 = 11:00AM | Aashish | General Discussion | 1 | March 24th, 2005 04:43 PM |
spell check on 6.00 | Tommy | Installation & Setup | 1 | March 16th, 2005 04:29 AM |
What formula can excel xp calculate hours worked ie 2145 to 0600. | Mad Cow | General Discussion | 2 | September 8th, 2004 09:55 PM |
unable to send email on outlook express version 6.00 | john hibbard | Outlook Express | 12 | June 3rd, 2004 09:29 PM |