Hi everyone,
I'm a very novice excel user and would like help with one of the projects i'm working on at work.
I made a drop down list in Columb A for Gender (male, female) and in Columb B for Age (19-30, 310-50, 50+)
What I would like is if someone chose Male from Column A and chose 31-50 range from Column B, In column C it would produce how much fruits they should have eg. 2 serving, ets.
I have attached what i have so far, I just need help with fomulating the formual. Any help would be appreciated.
Thank you!
Bookmarks