Hi
I need to enter an select case statement into excel so that the value of a field is generated based on the option selected in a drop down. I cannot use nested IF statements as there are more than 7 options. I would like to know how to use the select case statement to get round this – e.g where do I put it in excel, as what is the syntax?
A case select can appear in Excel formula using LOOKUP function
e.g. the dropdown has link cell A1, and the fill range is A2:A5 which have a,b,c,d in each of the cell, if you want to return the place of the choice picked
=LOOKUP(A1, {"a","b","c","d"}, {1,2,3,4})
If you pick a from the dropdown, 1 will return, if picked c, 3 will return.
In case you need different formula for each choice, say pick a to sum C1, C2, pick b to subtract C2 from C1, pick c to multiply C2, C1, pick d to divide C1 by C2
=CHOOSE( LOOKUP(A1, {"a","b", "c","d"}, {1,2,3,4}), C1+C2, C1-C2, C2*C1, C1/C2)
Please contact for more details
can u slove my problem..any SQL user can slove it
hey if i have ten records in my salary coloumn and i want to know the salary of the 5th greatest one.but use the subquery command take lot of time (select from max(sal) from emp where sal<(select from max(sal) from emp) writng this 5 times will take lot of time can any 1 tell me how to find it in a better ways using co-realted query(finding by nth place from which i can find directly 5th maximum value) please help me
Here’s a way to do it in Oracle:
select * from (select sal from emp order by sal desc) where rownum=5;
And for MySQL:
select sal as salary from emp order by sal desc limit 5,1;
Explanation:
The query generates a list of all salaries and orders them from highest to lowest. It then chooses the 5th row which will contain the 5th highest salary.
sorry guys. i only joined yesterday and this is my thrid question. anyways, i heard that some women hardly ever get inner orgasms while some of us get them easily. is that true? does heredity have anything to do with it?
All women are different and stimulation comes in many forms. The "inner" (vaginal) orgasm is harder to come by because every womans "G spot" (the area that leads to orgasm when stimulated) is in a different place. The "outer" (clitoral) orgasm is much more common and somewhat "easier" to come by (pun intended). This area is usually much easier to find (for some, don’t get me wrong, there are those that simply can not find it) and therefore, a more common occurrence. An orgasm is an experience that usually comes with age and experience. The best advice that I ever got was that you need to be able to achieve orgasm by yourself before you’ll ever be able to do so with a partner. How else will they know where you like to be touched if you can’t tell them from personal experience?
I don’t think your family history or genetic makeup has anything to do with what will get you to orgasm. People put so much pressure on women to have an orgasm that sometimes they don’t just relax and let it happen. I think the fact that some women can and some women can’t means that the women who "can’t" just aren’t comfortable enough with their own bodies to find that "spot" or that "rhythm" themselves.
solution + Prove that from any set of ten distinct two-digit numbers (in the decimal system), it is possible to select two disjoint, non-empty subsets whose members have the same sum
If false, then all disjoint sums are distinct. So how many are there? Essentially, pick some terms and then pick some terms from what’s left. How many ways can i pick some terms so that something is left? I can pick up to nine terms
out of ten. Picking 1 ten ways, picking 2 , 10*9/2!, picking 3,
10*9*8/3!,…….., picking 9, ten ways again. This sum is
2^10 – 2 = 1022 . We don’t need to pick sets from what is left because the size of this number will suffice. These sets are distinct but not all are disjoint. Yet we can see that distinct sets have distinct sums
because we can remove their intersection from each pair
examined to obtain a disjoint pair which has a pair of distinct sums under our assumption that the result for this problem is false. So we have at least 1022 distinct values less than the maximum possible sum of ten distinct two-digit numbers
which is 99+98+97+….+90 = 945. This is a contradiction,
and the result stated by the asker is proved.
When has the existence of authority lead to the oppression of a less privileged group by a more privileged group???
Oh, good lord – this is the way this idiotically, unjust, and brutal world functions!!
Read up on the recent histories of Russia, China, Iran, Iraq, Israel, Germany, South Africa, Spain, Argentina, Chile, Brazil, France, England, or well, Ancient Greece and Rome!!
If you’re from the USA, try the relationship between the US and the native "Indians" or the blacks – which still continues.
The list is as long as human history, it seems.
Hello and thank you for looking..
I am using Excel to accumulate special requests for my customers when they come in my store. I collect the date, item requested, company, customer name and telephone number onto the spreadsheet.
Is there a way to create or use a form (program) that can ask my clerk these simply questions and then it would just insert them into my excel spreadsheet?
Thanks
As long as your customer can’t see the other customer’s details that have previously been entered, a simple solution would be to just have the questions as column headings and then your clerk could enter the details in a new row for each customer.
If you want something more sophisticated, click on View > Toolbars > Forms and have a play designing a form using checkboxes and option buttons, but to create an active program you will need experience of Visual Basic.
Hope this helps
My yahoo group members are having a hard time accessing the edit feature on a database table. I’ve set the group settings to allow the members to do it but the database itself is not working properly. How do I go about fixing this?
there’s also setting with in creating a data base that disallows others from editing it, maybe that’s the problem.
I am trying to make a simple query, I have two fields in a table that have yes or no answers. I need to get the query to show all the info with no as the data. I typed like*no* in both criteria boxes and it is only showing me the boxes when both fields have no. I need to see the boxes for when one field has yes and one has no as well. How do I do this?
In the query editor, make sure you have all the fields you want to show ticked, including the yes/no field.
Then only put in NO in the criteria box under the yes/not field. Access should auto fill anything else it needs such as * or like.
i have all the plugs in the right spot but the ps3 or the tv cant seem to find the hdmi. Any help?
if it switches back to normal then your fine all you need to do is change the Tv display to HDMI instead of Component or AV
Write a SQL statement to show the Initials, Name and TotalPay (HoursWorked * Salary/hour) grouped per employee for the first 15 days of May 2006.
Consider that the salary per hour is $12.
-totalpay is a new column that needs to be added with a ‘alter’ statement, possible subquery
Home work?
Here is a guide:
http://www.sql-ex.ru/help/