+ Reply to Thread
Results 1 to 4 of 4

If statement problem

Hybrid View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Laos PDR
    MS-Off Ver
    Excel 2007
    Posts
    45

    If statement problem

    Hi guys

    Attached is a small excel file I have an excisting formula that works correctly but would like to include additional criteria. As per my file I got the 1 criteria to work but is having difficulty with the 2nd criteria. can anybody please help

    Thanks guys
    Regards
    Peter
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: If statement problem

    i took a look at your file. you have a lot of "what you want" but i cant see any data to apply it to? please include your data, showing what you have, some examples what your expected outcome is and how you arrived at that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    Laos PDR
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: If statement problem

    Hi FDibbins attached a simple sample of what formula does hope it helps
    Attached Files Attached Files

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If statement problem

    Maybe.

    =if((Turnover!A4="I";0;Your formula......
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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