+ Reply to Thread
Results 1 to 7 of 7

merge existing if formula to convert cl to litres

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    merge existing if formula to convert cl to litres

    I have a table where I convert packing drinks from ml to litres , if it is in litres , then It remains same .

    But I have now ,french system which in cl , how convert the cl to litres and merge them with the actual formula from column D to G.

    the packing is split in various columns from D to G

    e.g 6*5*1L is split to their respective header columns 6 5 1
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: merge existing if formula to convert cl to litres

    Use this formula in G2 and copy down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: merge existing if formula to convert cl to litres

    =IF(F2="","",F2*INDEX(_t,MATCH(AGGREGATE(15,6,INDEX(_t,,2)/ISNUMBER(FIND(INDEX(_t,,1),A2)),1),INDEX(_t,,2),),3))
    in case if CL is not last
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: merge existing if formula to convert cl to litres

    @tim20110

    thanks for formula,but can you give me an example with the small function as I worked with excel 2007 which will involved ctrl sht enter

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: merge existing if formula to convert cl to litres

    @JEAN1972 did you check my formula in post #2?

  6. #6
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: merge existing if formula to convert cl to litres

    =IF(F2="","",F2*INDEX(_t,MATCH(SMALL(IF(ISNUMBER(FIND(INDEX(_t,,1),A2)),INDEX(_t,,2)),1),INDEX(_t,,2),),3)) as array formula
    sorry, didn't notise

  7. #7
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: merge existing if formula to convert cl to litres

    @6StringJazzer formula works well thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 09-13-2017, 11:56 AM
  2. [SOLVED] formula to convert ml to litres automatically to a specific column
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2017, 11:10 AM
  3. convert existing cell formula to vba and copy down if cell has a value
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 04:31 AM
  4. [SOLVED] How to calculate fuel burn in litres per H:MM
    By nje in forum Excel General
    Replies: 3
    Last Post: 09-17-2012, 07:51 AM
  5. [SOLVED] Excel Formula for "Litres per 100 Km"
    By Expara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 01:25 PM
  6. Excel Formula for "Litres per 100 Km"
    By Expara in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2006, 11:45 AM
  7. [SOLVED] Convert litres per 100km to miles per gallon easily
    By Ann Cardus in forum Excel General
    Replies: 4
    Last Post: 08-16-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1