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
Bookmarks