Question about Microsoft Excel for PC
Example, Say in Cell A1 "Breakfast" is typed in. In A2 I'd like a drop down menu to appear, i.e. with cereal, toast, yoghurt, eggs or bacon to select from.
However, if "Lunch" is entered in A1, a different drop down menu should appear, i.e. sammy, salad, pasta.
And finally, if "Dinner" is entered in A1, yet a different drop down menu should appear, i.e. steak, chicken, tuna, stir fry.
Is this possible and if so, what is the formula to be used?
Yes...no....yes....and yes. And if that sounds like a funny response let me explain. First of all you can write a formula for a specific cell (or cells or interrelated cells where you menus would display). It takes a while and if you are new to the syntax it could take a couple hours even (let's assume you are not a math major). Using Access, for something this apparently simple, I would not suggest (another learning curve but admittedly a reasonably easy one). But, this is the second yes, the easiest way to do this would be to simply insert a "comment". When you hold the cursor over the cell...your data...i.e. menu...will pop up. And yes...(last yes) you could have Sunday thru Monday across the top and Breakfast, lunch and dinner in the right hand column. Now this assumes what you have said is what your are trying to do...effectively meal planning...and you are not trying to plug in the inventory in the fridge to develop a shopping list.
Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.
Posted on Feb 05, 2008
Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!
Posted on Jan 02, 2017
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011  Microsoft EXCEL 2004 for Mac



on Nov 19, 2013  Microsoft Excel Computers & Internet
Jun 06, 2010  Microsoft Excel for PC
Sep 18, 2009  Microsoft Excel for PC
Jul 02, 2009  Computers & Internet
Oct 26, 2008  Microsoft Office 2003 Basic Edition...
Oct 22, 2008  Microsoft Excel for PC
Oct 09, 2008  Microsoft Excel for PC
Feb 26, 2008  Microsoft Excel for PC
Jan 31, 2008  Computers & Internet
Jan 28, 2016  Microsoft Excel for PC
Dec 12, 2013  Microsoft Excel for PC
Jul 23, 2013  Microsoft Excel for PC
86 people viewed this question
Usually answered in minutes!
you are asking excel to do the job of access...try using access for this...excel is merely a place to store data...access is a tool to utilize that data
×