If Then Else?? #2

1	A	B	C	D	E	F	G	H	I		
2	Country		MSIA	SPORE	HK	China	Japan	Thai	Viet
3											
4	Base		0.10	0.95	0.13	0.13	0.13	0.12	0.10
	(1-Bucket + 1-Crate)
					
5	1-Bucket	0.04	0.04	0.04	0.04	0.04	0.12	0.04		
6	1-Crate		0.09	0.10	0.09	0.09	0.09	0.09	0.09		
7											
8	Raisin	R	0.01	0.01	0.02	0.05	0.03	0.01	0.01		
9	Grape	G	0.17	0.19	0.15	0.16	0.24	0.08	0.12		
10											
11	Unripe	UC1	0.07	0.07	0.08	0.07	0.07	0.03	0.05		
12	Unripe	UC2	1.00	1.03	1.56	0.95	0.95	0.45	0.67		
13	Unripe 	UC3	0.29	0.30	0.45	0.27	0.27	0.13	0.19		
14	Ripe 	RC1	0.57	0.59	0.69	0.54	0.54	0.25	0.38		
15	Ripe 	RC2	0.39	0.40	0.61	0.37	0.37	0.17	0.26		
16	Ripe 	RC3	0.29	0.30	0.56	0.26	0.26	0.12	0.18		
											
											
											
						Base		Add-on Bucket		Add-on Crate	Raisin/Grape		Rated Ripe / Unripe
Malaysia/1-Bucket/1-Crate/Raisin	     =	C4	+	((1-1)*C5)	+	((1-1)*C6)	+	C8		
Malaysia/2-Bucket/2-Crate/Raisin	     =	C4	+	((2-1)*C5)	+	((2-1)*C6)	+	C8		
Malaysia/2-Bucket/3-Crate/Grape/Unripe (UC1) =	C4	+	((2-1)*C5)	+	((3-1)*C6)	+	C9	+	C11
HongKong/1-Bucket/1-Crate/Grape		     =	E4	+	((1-1)*E5)	+	((1-1)*E6)	+	
E9

Japan/5-Bucket/7-Crate/Grape/Ripe (RC2)	     =	HLOOKUP("JAPAN",$D$2:$J$16,3,FALSE)								
								(5-1)*(HLOOKUP("JAPAN",$D$2:$J$16,4,FALSE))						
									(7-1)*(HLOOKUP("JAPAN",$D$2:$J$16,5,FALSE))				
														???		???
how to go about to obtain ??? using If Then Else...


0
3/22/2012 5:58:37 AM
excel 39880 articles. 2 followers. Follow

0 Replies
835 Views

Similar Articles

[PageSpeed] 6

Reply:

Similar Artilces:

If Then Else??
Cat Indic Apple Banana Coconut Durian Ripe (R) 10 30 50 70 Unripe (U) 60 40 20 10 Seeded (SD) 70 0 0 80 Seedless(SL) 0 70 70 0 If I have a 1 column for either Fruits (Apple, Banana, Coconut or Durian)and another on Indicators (R, U, SD, SL), at the row that I have maybe listing Apple & Unripe, I want to extract the quantity (60), how do I go about with the If Then Else function? Hi, Am Mon, 19 Mar 2012 07:11:36 GMT schrieb khoo nora: > Cat Indic Apple Banana Coconut Durian > Ripe (R) 10 30 50 70 > Unripe (U) 60 40 20 10 > Seeded (SD) 70 0 0 80 > Seedless(SL) 0 70 70 0 ...

ASP.NET 2.0: problem using xmlDataSource and GridView...
I am having trouble using XML in an ASP.NET 2.0 webform. Using ASP.NET 2.0 beta 2, I have created a blank web page in a C# website. I have added an XML file (soData.xml), structured as follows: <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?> <VFPData> <ac_sodata> <iono>Vendor</iono> <sodate>2004-03-04</sodate> <sono>164</sono> <custno>ADG1</custno> <item>HD10.0G</item> <descrip>10.0 GB EIDE Ultra DMA 9.0ms Hard Disk Drive</descrip> <qty...

Quicken to Money #2
When I convert from QUICKEN to MONEY 2004 does that convert my register too? Yes - it doesn't convert Household Inventory though. NB Money is always one "year" behind Quicken, so M2004 will only convert Q2003 or earlier. -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny. For wishes or suggestions see http://register.microsoft.com/mswish/suggestion.asp or for UK wishes email to mnyukwsh@microsoft.com. "Walter Finney" <wfinney@wi.rr.com> wrote in message news:daff01c43b4d$c67...

Crop Marks #2
I'm printing admittance tickets 5 rows X 2 columns per page. 4.5x 2.2 page size. Using the business card template. I have used advanced settngs to request crop mark but none are printing. Can anyone offer a suggestion, please. Thanks for your help. Lee You will not get crop marks if your publication fits the page. The only work around would be to use a lesser amount of tickets per page. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Lee Hunter" <LeeHunter@discussions.microsoft.com> wrote in message news...

archive.pst.2
In process of searching thru files on my PC I found two archive.pst files : 1- archive.pst 1.2 GB (Todays file date) 2- archive.pst.2 1.5 GB (older file date) Is it safe to delete the archive.pst.2 file? Thanks Steve Rename it so it has only the pst extension. Then look what's inside by opening it in Outlook through File-> Open-> Outlook Data File... -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "Steve Klenner" <steve_klenne...

Desktop Alert #2
Hi all, Any way to configure Desktop Alert so that it displays an alert when mail is received and routed (via rules wizard) to another folder? I have many sub-folders in my inbox for specific people, and rules to have those messages moved upon receipt to the appropriate folder. But Dekstop Alert does not show when these people send me email - only when email is received and delivered to the Inbox. Thanks, JS It can be set as an Action in the rule -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Creating Signatures -Create an Office XP CD slipstreamed with...

Outlook 2002 e-mail #2
Incoming e-mails are being automatically deleted by Outlook 2002, what can I do to stop this? Are you sure or do you have a view applied to the in-box? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Aerozona asked: | Incoming e-mails are being automatically deleted by | Outlook 2002, what can I do to stop this? ...

rms 1.2 vs 2.0
I have a 2 stores plus HQ and web integrator and mobile suite. I am considering upgrading to 2.0. A couple of questions: 1. It is it an upgrade that can be done with only phone support (i've done all my own installs QS2K, upgrade to RMS etc.) and is it something that should wait until after the holidays? 2. Are there significant changes between these versions (besides the different dbase)? 3. I need to be able to edit customer info at each store - I'm considering buying the customer edit add-ons - will I need to still buy this or does 2.0 allow editing customers at the store le...

if else if...
hello all!! any reason why this should not work correctly ? ;))) tx !!! If aWS.Range("M52").Value = True Then aWS.Range("M80").Value = 5 Else If aWS.Range("M51").Value = True Then aWS.Range("M80").Value = 4 Else If aWS.Range("M50").Value = True Then aWS.Range("M80").Value = 3 Else If aWS.Range("M49").Value = True Then aWS.Range("M80").Value = 2 Else If aWS.Range("M48").Value = True Then aWS.Range("M80").Value = 1 End If End If End If End If End If Hi, Well it&...

Filtering problem #2
Dear All, Is it possible to return results from the same row but within differen columns using a filter? I appreciate your help -- gaftali ----------------------------------------------------------------------- gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=645 View this thread: http://www.excelforum.com/showthread.php?threadid=47302 Hi there, Not sure what you mean there. Can you explain 'return results'? -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) "gaftalik" <gaftalik.1wdxqa_1128441903.0178@excelforum-n...

Someone else's job, someone else's template
Complete novice at Publisher, must use previous employee's template & text for new job. Text in Word document. Am I merging, cutting/pasting to text box, importing, or something else? Please help; desperate. Create a text box, right-click, click change text, click text file, browse to your Word document. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Ali" <Ali@discussions.microsoft.com> wrote in message news:F00ADD8A-0715-43C8-8975-007D40E34D72@microsoft.com... > Complete novice at Publisher, must u...

Large Attachments #2
My Microsoft Outlook wont send large attachments (e.g., 1M.) How can I remedy this problem? How large are the attachments? Are you connecting to an Exchange server or using a POP/SMTP mail system? Usually on Exchange, the default message incoming and outgoing is ~10MB. This limit can be adjusted on the Exchange server for you mailbox. Talk to your system administrator to see if that is your problem. Jerry >-----Original Message----- >My Microsoft Outlook wont send large attachments (e.g., >1M.) How can I remedy this problem? > >. > ...

Money Deluxe 05 #2
I purchased Money Deluxe 05 from the Microsoft website a week ago(downloaded it) and paid $63.00.Once I installed the program I keep receiving a screen asking me to upgrade the TRIAL VERSION to the Deluxe version even though I have paid 63.00 and my credit card has been charged. I contacted Microsoft for help and I was told that soon I will receive a letter in the mail explaining how to get rid off that screen..nothing else...Anybody knows how to get to the real thing and get rid off the trial version. I love the program but this goes beyond any imagination!!!!!..Help!!!!! ...

Find max value from 3 cells, return text, but 2 max values same!
Hi, I'm using a simple formula to find and return the maximum value from 3 compared columns (N, Q & T) and place that max value in column U (same row). Equation in column U is: =MAX(N3,Q3,T3) SK17 EC3 PL2 Max Text N O P Q R S T U V 3 6 5 1 6 4 6 3 3 6 5 5 5 2 5 6 1 ...

DYNAMIC RANGES #2
I am looking to develop a macro that will allow me to select a range of cells dynamically. I have created a mapping template that maps user defined fields to native fields, but each file that I map has a different number of rows of data. Rather than simply selecting a range of cells statically, I am hoping that there is a macro out there that will allow me to catch all data in a column by dynamically assigning my range to include all rows of data up to the last row containing information and no more. To add to this issue, not all intermediate rows will contain data, but it is important tha...

Synchronize between 2 money files
I would like to extend usage of money for my wife's finance. For this functionality I would like to manage my finance from my notebook, which is not always connected to same net as my wife's notebook. Therefor I would like to have some possibility of synchronization of several accounts between these two computers (even shared datafile could be kept on third computer with shared drive). I don't wish to publish financial data to any web server. Is there any solution for this kind of functionality? I'm thinking about similar solution as Ultrasoft Money for Palm uses for syn...

Outlook Won't Stay Open #2
HELP! Suddenly, out of nowhere, my Outlook (2007) will NOT stay open. It loads, and then I get the "encountered an error and must close" message. I can't even back up my .pst file because the program won't stay loaded. Any clues. (Windows XP SP3) Jan Groshan wrote: > HELP! Suddenly, out of nowhere, my Outlook (2007) will NOT stay open. It > loads, and then I get the "encountered an error and must close" message. I > can't even back up my .pst file because the program won't stay loaded. Any > clues. > (Windows XP SP3) > > Ho...

How do I...? #2
(In XL 2003) I have a cell that is validated to only contain any of the numbers 1 through 5. What I want is to have another cell that will only accepts a range of numbers based on the value in cell 1: A 1<can only contain 1,2,3,4 or 5> 3<if A1=1, then this cell can only contain 0.01 through 0.20; if A1= 2, this cell can only contain 0.21 through 0.40 etc.etc.> I have tried putting a vlookup in the cell validation formula but this doesn't seem to want to work. Any suggestions would be much appreciated. TIA Dave Try a custom Validation form...

Automation #2
I have created five (5) grids within Excel consisting of correlations comparing various commodities. Each correlation grid represents years of data (i.e., 5yr, 10yr, 15yr, etc.). Right now, I am manually checking each commodity across every grid to see which other commodities are closely or loosely correlated. At the same time, I check to see if these correlations are consistent across all years of data. Once the correlation is manually validated, I type the summary list into yet another worksheet. Basically, here's an abbreviated example of what the grids look like: AD BO BP C CC CD...

EDC #2
Hello, I am getting a "Connection Error" when tryging to use EDC. It is definitely connect to the Internet but RMS thinks otherwise. Thank you in advance for any help you may provide! Dan Are you on the TSYS platform? Are you getting: - "Connection Error = 400" OR - "Status Failed, Approval Connection Error" -- Jocelyn "Daniel Suh" wrote: > Hello, > > I am getting a "Connection Error" when tryging to use EDC. It is definitely > connect to the Internet but RMS thinks otherwise. > > Thank you in advance for...

Send/Receive #2
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5A17F.E6DD0490 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Since upgrading to Exchange 2003 from Ex 5.5, when we go to Send/Receive = we get the error 0x8004010F: The Operation failed. An object could not = be found. My understanding from KB articles this is associated with = Offline Address Book. It looked as if our old OAB was corrupt as when I = went to rebuild it, it gave an error. I have created a new OAB and set = it as default yet my send/receive still gi...

How do I set up 2 email accounts with 2 differnt inboxes?
I set up 2 different email accounts in the same Outlook. Is there a way i can have different inboxes set up for each one so I dont have to "Set as Default" each one and have them both go into the same inbox? tnorton <tnorton@discussions.microsoft.com> wrote: > I set up 2 different email accounts in the same Outlook. Is there a > way i can have different inboxes set up for each one so I dont have > to "Set as Default" each one and have them both go into the same > inbox? Outlook version? Account types? -- Brian Tillman -Microsoft Office Outlook 2...

DomainPrep #2
Hello I have in error whwn I try to update sp2 The solution perform domainprep can i run domainprep on existing exchange 2003 installed Thank Yes, you can run DomainPrep as many times as you want even with servers installed. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Christian" <Christian@discussions.microsoft.com> wrote in message news:09D7BCB8-0097-4694-ADFF-AF378FA5A8BB@microsoft.com... > Hello > > I have in error whwn I try to update sp2 > The solution perform domainprep > can i run domainprep on existin...

if then else statement
On my report I have a field that I need help with. I have written an =If statement to try and capture all of the variables, but it is too long, so now I need to write the same expression in code. Here is what I have in my =If statement (which resides in the Detail area of the Report): =IIf([costcode]="013210" And [costtype]="05320",[txtActualCost]/[txtCraftLabAct],IIf([costcode]="020110" And [costtype]="05320",[txtActualCost]/[txtFirewatchLabAct],IIf([costcode]="064201" And [costtype]="05320",[txtActualCost]/[txtC...

A challenge #2
Hi all you masterminds, I've spent some time trying to solve this problem. Not exactl because I need this, but because it's challenging. At least to me i is. So, can you make a worksheet function that reverses a string? That' it basically. - Asse -- Message posted from http://www.ExcelForum.com Yes, something like this. I haven't tried to code but.. Dim variable as string, Result as string Dim Length as integer, x as integer Length = len(variable) x=Length while x<>x-Length Result = Result & mid(variable,x,1) x=x-1 wend msgbox Result Cheers Paa -- Message ...