LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steved
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time formula 0600 = 11:00AM Aashish Excel Discussion (Misc queries) 1 March 24th 05 04:43 PM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"