Results 1 to 3 of 3

Nested IF Function Help?

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    houston
    MS-Off Ver
    Excel 2010
    Posts
    12

    Nested IF Function Help?

    I've created a nested if function and it isn't working properly -- or rather, it's not working at all. I get an error upon entering it.

    So here are the conditions. If a plant sells less than 2,000 units during three seasons, it's undersold.

    If it's undersold, it may be discontinued ("DNP") if the germination failure rate is higher than 10%, or if it takes less than 50 days to harvest.

    If it's not discontinued but still undersold, it should be monitored ("PM") if the sales have changed by less than 2%.

    If it's not undersold at all then it is planted ("P").



    Anyway, here is my nested if statement -

    =IF(SUM(G5:I5)<2000,IF(E5>.10 OR C5<50,"DNP",IF(J5<.02,"PM","P")),"P")

    When I try to enter it into the spreadsheet, it tells me that there is an error. Does anyone know what it could be, or do you see any obvious mistakes in my formula?



    Edit: I fixed the OR function so the formula now reads:

    =IF(SUM(G5:I5)<2000,IF(OR(E5>.10,C5<50),"DNP",IF(J5<.02,"PM","P")),"P")

    But I'm still getting an error.
    Last edited by youradhere4222; 04-09-2012 at 10:08 PM.

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