+ Reply to Thread
Results 1 to 4 of 4

Converting nested if to Macro

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    VIC
    MS-Off Ver
    Excel 2003
    Posts
    3

    Converting nested if to Macro

    Currently I am using below nested if statements to get the results. I want to convert into Macro for future use. And I want results to display on last empty column and until last empty cell. Please help me to sort this out

    =IF(L2="BI",IF(M2="AL","Onsite allocated to auction",IF(M2="RL","Onsite released for auction",IF(M2="NR","Onsite NOT released for auction",IF(M2="UN","Onsite unsold",0)))))

    =IF(OR(L2="ex",L2="sy"),IF(M2="SO",IF((I2>"10/08/2011"+0)*(I2<TODAY()),"Recently Sold",0)))


    Jas
    Attached Files Attached Files
    Last edited by Cooljazz; 10-20-2011 at 11:25 PM.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Converting nested if to Macro

    a workbook with some data in it would be greatly appreciated.

  3. #3
    Registered User
    Join Date
    10-18-2011
    Location
    VIC
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Converting nested if to Macro

    Quote Originally Posted by p24leclerc View Post
    a workbook with some data in it would be greatly appreciated.
    thanks for your reply i have attached it

    Jas

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Converting nested if to Macro

    Hi

    Here's one way.
    Please Login or Register  to view this content.
    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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