Data is entered in Worksheet "Micro Macro - Enter Data". Trying to figure out excel formula that calls out, "Low", "Good" and "High" for nutrient analysis. In Worksheet "Lettuce", cell E8 needs to say, IF cell D8 is less than B8 its "Low" if D8 is between Cell B8 and C8 its "good" and IF D8 is above C8 its "high". Please help.
Last edited by ericinarcata; 02-26-2020 at 08:50 PM.
=IF(D8<B8,"low",IF(AND(D8>=B8,D8<=C8),"good","high"))
Last edited by mehmetcik; 02-26-2020 at 09:05 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Will that same formula work for all Cells in the column? Not working on the rest of the cells. What does the D8<=8 mean in the formula? Thanks.Originally Posted by mehmetcik
Apologies
=IF(D8<B8,"low",IF(AND(D8>=B8,D8<=C8),"good","high"))
As there are No $ symbols you can fill this formula down and it will work.
That did it. Merci!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks