+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Need cell to change to B fruit or X Fruit depending other cells.

Hybrid View

  1. 06-14-2012, 10:06 AM #1
    srgtennis
    srgtennis is offline
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Need cell to change to B fruit or X Fruit depending other cells.

    I need the cells in column B to be "Blank, B Fruit, or X Fruit" depending on other cells. Right now I have it if Column AH is Under 75 % then B Fruit is come up in column F and if it is over 75 then it is blank which was fine for awhile until they want to change it.

    If Column AD1 has a "yes" for maggots in the column then Column B1 has to say X Fruit doesn't matter what percent AH1 is. Maggots trump everything.

    If There are no maggots in fruit, then if column AH1 is 75 or lower percent then there needs to be B Fruit in Column B1.

    If there are no maggots and the percent is above 76 or higher then column B needs to be blank.

    If there is utility in the variety column F then we don't need there to be X or B fruit in column F.

    Maggots is X Fruit

    Under 76 is B fruit

    Higher than 76 is Blank

    Utility is Blank
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-14-2012, 10:36 AM #2
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Need cell to change to B fruit or X Fruit depending other cells.

    Test this (in B6 and down):

    =IF(AD6="Yes","X Fruit",IF(AND(F6<>"Utility",AH6<=75),"B Fruit",""))
    Last edited by Cutter; 06-14-2012 at 10:45 AM. Reason: Amended percentage value
    Reply With QuoteRegister To Reply
  3. 06-14-2012, 10:38 AM #3
    tkowal
    tkowal is offline
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Need cell to change to B fruit or X Fruit depending other cells.

    Try this formula for Column "B6" then copy down

    =IF(UPPER(AD6)="YES","X Fruit",IF(UPPER(F6)="UTILITY","",IF(AH6<=75,"B Fruit","")))
    Ted
    "Live Long and Prosper"
    Reply With QuoteRegister To Reply
  4. 06-14-2012, 10:41 AM #4
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Need cell to change to B fruit or X Fruit depending other cells.

    Or maybe it's this:

    =IF(F6="Utility","",IF(AD6="Yes","X Fruit",IF(AH6<=75,"B Fruit","")))

    since Utility trumps maggots
    If there is utility in the variety column F then we don't need there to be X or B fruit in column F
    Last edited by Cutter; 06-14-2012 at 10:45 AM. Reason: Amended percentage value
    Reply With QuoteRegister To Reply
  5. 06-14-2012, 10:46 AM #5
    srgtennis
    srgtennis is offline
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Re: Need cell to change to B fruit or X Fruit depending other cells.

    Should work Thanks a ton!!
    Reply With QuoteRegister To Reply
  6. 06-14-2012, 10:49 AM #6
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Need cell to change to B fruit or X Fruit depending other cells.

    You're welcome. Thanks for the 'star tap".
    Don't forget to mark your thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1