Results 1 to 5 of 5

assistance to modify complex formula from reading 30ea to 30

Threaded View

JEAN1972 assistance to modify complex... 12-08-2018, 05:09 AM
Richard Buttrey Re: assistance to modify... 12-08-2018, 05:51 AM
JEAN1972 Re: assistance to modify... 12-08-2018, 07:51 AM
Richard Buttrey Re: assistance to modify... 12-08-2018, 09:45 AM
JEAN1972 Re: assistance to modify... 12-08-2018, 11:09 PM
  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,142

    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

    
    =IF(OR(AS2="L",AS2="kg"),IFERROR(1/(1/(P2*Q2)),""),IF(OR(AS2={"U","m2","m","2U"}),SUBSTITUTE(LEFT(AB2,LEN(AB2)-0)," ","")+0,""))
    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

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