+ Reply to Thread
Results 1 to 5 of 5

assistance to modify complex formula from reading 30ea to 30

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

    assistance to modify complex formula from reading 30ea to 30

    I have a worksheet which breaks down quantities from column AB2 based on column AS statisical unit consists of kg L,U,m,m3 2u .

    on column u qty1 header using formula below

    Please Login or Register  to view this content.
    my issue that now the column U shows no more ea ,pks, in the digits. that 30.00EA OR 30.00PKS now reads 30,2 ,15 and so on.

    column BC is the example that column U will show now .

    Can anyone assists , the issue of the formula is in red as below.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: assistance to modify complex formula from reading 30ea to 30

    Please clarify what results you expect. Column BC is the same as Col Ac
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

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

    Re: assistance to modify complex formula from reading 30ea to 30

    Yes I confirm column BC same as AC

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: assistance to modify complex formula from reading 30ea to 30

    Quote Originally Posted by JEAN1972 View Post
    Yes I confirm column BC same as AC
    Yes I understand that but if AC contain the information you want, other than a trivial =AC2 in BC2, what else are you expecting.

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

    Re: assistance to modify complex formula from reading 30ea to 30

    I sorted it .

    thread closed

+ 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. Reading Complex Binary Files into a worksheet
    By anthony1312002 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 06-04-2018, 07:42 AM
  2. Inherited Complex Formula, Need Assistance to Change
    By DHartwig35805 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-22-2013, 04:29 PM
  3. VBA assistance to modify code
    By tyantorno in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 11-20-2012, 06:43 AM
  4. Modify complex autocopy from several sheets into one
    By Hello23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2012, 10:19 PM
  5. Need assistance with complex IF formula
    By mccormickj in forum Excel General
    Replies: 0
    Last Post: 09-01-2011, 01:13 PM
  6. Need to modify 2 complex formulas using IF, THEN, ElSE
    By daymaker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2011, 07:24 AM
  7. Modify this complex formula using IF THEN ELSE
    By sunny17 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2011, 10:44 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