Results 1 to 27 of 27

Convert Formulas to VBA Code

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    Question Convert Formulas to VBA Code

    Dear Experts,

    Kindly Convert the below formulas to VBA code.

    Sheet1 having morethan 25000 lines. Please help me its very urgent.

    =IF(BT3=AI3,"CURRENT MONTH","CATCHUP/CATCHDOWN").............Values in (AK3)
    =IF(CB3<0,0,IF(CB3>1,1,CB3))........ ...................Values in (AL3)
    =IF(ISERROR((AL3/CD3)*MIN(CF3,CG3,CE3)),0,((AL3/CD3)*MIN(CF3,CG3,CE3))) .............Values in (AM3)
    =IF(BZ3="CURRENT MONTH",IF(AL3<0,0,AL3),0)............................................Values in (AN3)
    =IF(CC3=0,0,SUMIF(A:A,A3,CC:CC)).......................................................Values in (AO3)
    =IF(BZ3="CURRENT MONTH",IF(C3<$CG$1,100%,IF(ISERROR((D3-C3)/($CG$2-$CG$1)),100%,((D3-C3)/($CG$2-$CG$1)))),0)....Values in (AP3)
    =IF(BZ3="CURRENT MONTH",IF(C3<$CG$1,100%,($CG$2-C3)/($CG$2-$CG$1)),0) ...............................Values in (AQ3)
    =IF(BZ3="CURRENT MONTH",IF(D3="NULL",100%,IF(D3>$CG$2,100%,(D3-$CG$1)/($CG$2-$CG$1))),0)...............Values in (AR3)
    =IF(BZ3="CURRENT MONTH",IF(OR(AO3="NULL",AO3=100633,AO3=104857,AO3=100634),0,AL3),0) ..............Values in (AW3)
    =IF(BZ3="CURRENT MONTH",AK3,0) .................................................................Values in (AT3)
    =IF(BZ3="CURRENT MONTH",SUMIF(A:A,A3,CH:CH),0) ............................Values in (AU3)
    =IF(BZ3="CURRENT MONTH",SUMIF(A:A,A3,CI:CI),0) .........................................Values in (AV3)
    =IF(OR(CH3=0,AV3="company",BM3="Level 9",BM3="Level 10",BM3="Level 11",CJ3<80),"-",IF(CK3=0,"Buffer","-")).............Values in (AW3)
    =IF(CL3="Buffer",CA3,0) ........................................................Values in (AX3)
    =IF(OR(BM3="level 1",BM3="level 2"),CA3,0)..................................Values in (AY3)

    Thanks,

    Kumar
    Last edited by KumarPK; 04-29-2015 at 01:10 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba code to convert formulas into text.
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-05-2015, 04:31 AM
  2. Convert Cell Formula to Convert Text to VBA Code
    By PY_ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2014, 05:51 PM
  3. code to add formulas to a range with previous formulas appearing inside the new one
    By Excel-o-ratoR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2010, 06:02 AM
  4. Convert formulas in text into formulas
    By Tau in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2007, 08:31 AM
  5. [SOLVED] See code enclosed - Convert to formulas with absolute reference inculding the sheet references!
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2005, 04:06 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