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?


0
nora.khoo (1)
3/19/2012 7:11:36 AM
excel 39880 articles. 2 followers. Follow

1 Replies
716 Views

Similar Articles

[PageSpeed] 3

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

try Pivot Table:
drag Indicator to column and Apple, Banana, Coconut and Durian to
Values.


Regards
Claus Busch
-- 
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0
claus_busch (107)
3/19/2012 7:18:16 AM
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 ...

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&...

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...

Else If
Is there a function which will check in a specified cell for a number (should be from 1-10) and return a specific value based what number it found in that cell? Ex. IF(A1=1,"text1") IF(A1=2,"text2") IF(A1=3,"text3") IF(A1=4,"text4") IF(A1=5,"text5") IF(A1=6,"text6") IF(A1=7,"text7") IF(A1=8,"text8") etc... -- mallets123 ------------------------------------------------------------------------ mallets123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25090 View this thread: http://...

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...

something else
hi can we please talk about some news headlines here please thanks Hi, Sabian. > can we please talk about some news headlines here please Of course not. This newsgroup is dedicated to Microsoft Access database discussions and always has been. If you don't want to discuss this topic, you are welcome to subscribe to different newsgroups. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/e...

IF Then Else
Hi, Can someone point out to me what I have wrong with this IF statement. No matter what I change or where I place commas I still get a Syntax Error. I have a Form with one text box for an input number and a command button to run my query. I want to put in this IF statement in the query. It is suppose to do this. When a number is put into the text box the query checks for match in the dwFirstNumber field. If there is not any then to look in the dwSecondNumber field and then the dwThirdNumber for matches. This is what I entered on the criteria line of my query: If(([Forms]![tbl...

If,Then, Else
Could someone please help me with the correct syntax for the "IF, Then: Else: " command -- Alan S "Alansa59" <Alansa59@discussions.microsoft.com> wrote in message news:979ED94B-6E2C-4D89-9417-07C02D84CCE8@microsoft.com... > Could someone please help me with the correct syntax for the "IF, Then: > Else: > " command > -- > Alan S Sure. Let's say you want to do something if a file doesn't exist. It could be coded like this If Dir(MyFileName) = "" Then 'This part executes when the above condition ...

Anyone else get charged TWICE?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I just bought 8 from this website. Got charged twice. Anyone else have this experience? One for a little over 160 bucks and one for 149?? Don't even know who to get a hold of. Which website? If you double-click the "Submit" button on a vendor website, you will indeed get charged twice, because you have submitted two orders. Cheers On 28/03/10 3:07 PM, in article 59bb615b.-1@webcrossing.JaKIaxP2ac0, "jayson@officeformac.com" <jayson@officeformac.com> wrote: > Version: 2008 Ope...

If Then Else?
In the detail portion of my report, I have a field that is Est As % of Labour. The calculation I need is dependant on if a cost code and a cost type is this, then perform this calculation. Example: If [costcode]="020110" and [costype]="05320, take the EstimatedCost (of this costcode/costtype) and divide by EstimatedCost of costcode=013210 and costtype=05320. another: If [costcode]="036110" and [costype]="05511, take the EstimatedCost (of this costcode/costtype) and divide by EstimatedCost of costcode=031101 and costtype=05110 Any sugges...

If Then Else
I don't understand why this code not work Dim StrPr1 As String Dim StrPr2 As String Dim StrPr3 As String StrPr1 = "123" StrPr2 = "1234" StrPr3 = "12345" If Me.Text0.Value = StrPr1 Or StrPr2 Or StrPr3 Then 'Statment Else 'Statment End If Thank you Fredg "fredg" <fgutkind@example.invalid> wrote in message news:yzg8hd64pr2i$.ox32wavwm7zy$.dlg@40tude.net... > On Fri, 22 Feb 2008 11:40:55 -0800, a wrote: > >> I don't understand why this code not work >> >> Dim StrPr1 As String >> >> Di...

If-Then-Else Statement
It is not executing my If-Then-Else statement. It seems the only statement being executed is: Cells(Row, Col).Value = Range("K" & Row) and I only want it to do that if the condition is true, and put a 0 in each cell in the range if it is false. Can someone please look at my code and help me to get it to execute the If-Then-Else statement. Thank you. Updated code as follows: Sub Fill() Dim TestDate As Date Dim Col As Integer Dim Row As Long For Col = 13 To 29 For Row = 7 To 63 With TestDate = DateAdd("m", Range(&q...

Someone else's job, someone else's template #2
Thank you for the earlier help. Unfortunately, I need more, please. --I am using Publisher 2003; there are 4 master page templates that I am supposed to use. The first is for the title page, which I think that I can manage (maybe); the "Master B" is two-page with header and footer design in place; the "Master C" is one-page with same (perhaps this is the back cover -which will contain the organization's contact info.?) --I took your advice; it placed the document (6-7 pages) on the first page of Master B only; and you could only see the first page, even in Prin...

Anyone else?
Does anyone else have any suggestions for this dillema that I find myself in? Thanks in advance, MC The only thing that I can gather from your post is that you need to use the spelling checker. The grammar could be better too. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Michaelcip" <Michaelcip@discussions.microsoft.com> wrote in message news:B6EF553F-9538-44EE-BC74-127081A880F4@microsoft.com... > Doe...

If else when formula
hi, how if i want to compare a data entered by user in a column if it is matched with the DB created in excel? eg, if user key in 'A' in column G4, column H4 should display whichever data that matches the user key in 'A' from DB (column C) , all the matched 'A' alpabet from the DB column C will display in column H4. Thanks. regards, moon If I understand correctly, you want to enter a value in G4. Everything that matches this in column C should show in column H. Everything else in column H should be blank. If so, enter this in H4 then use fill fill handle to dr...

IF THEN ELSE CODING missing a step
I am using the following lines of code and I can not figure out why it is completely skipping the VBNO DOCMD. Is this worded incorrectly? Function Another_Record() MSGBOX "Do you wish to do another LRU update?", vbYesNo, "LRU UPDATE" If vbYes Then DoCmd.GoToControl "Serial Number" Else DoCmd.Close acForm, "EDIT CDS LRU ASSET" End If End Function Try if (Msgbox("blah bla",vbYesNo,"Title") = vbYes) then else end if "Curtis" <Curtis@discussions.microsoft.com> wrote in ...

dictionaries and else
Hi, I have recently bought a MacBook and would like to ask you whether the dictionaries installed in Office software vary between countries (if I buy Office in the US, for example, what dictionaries does it come with, and if I do the same in Switzerland, same question). And I would also appreciate your general comments on Office 2004 and Intel-Macs. Thanks. Depends on what you mean by dictionaries. If you mean things that offer definitions, all versions of Office 2004, whether English or other languages, only offer English language definitions for English words. If you mean the ability to...

What else to check
I am not able to send outgoing mail from exchange 2003 sp1. I have read every thred on this board and have tried Telnet and SMTPdiag. Manually they both work. The SMTPdiag gives me an error on the SOA records, but then goes on to communicate with the mail server. DNS seems to be setup correctly. Internet works fine. Could someone PLEASE give me a direction to look in ... can you send manually via telnet to port 25? If not, are you setup for a smarthost that is not responding? Can you post the exact message you receive in Outlook after attempting to send? Or does it sit in the queue?...

What else I miss?
Hi all, I enabled all global settings for mobile on the exchange server 2003. Configure Microsoft-SErver-ActiveSync to require SSL in IIS of Front end server since the FE has SSL certificate. Configure MIcrosoft-Server-ActiveSync to use basic authentication in FE server and use integrated authentication on the BE servers. Then, on the device, configure the server IP is the FE's public IP. But, somehow, it did not synronize? Can anyhone point out what steps I missed? Do I have to enable form-based authentication on the FE server to get it work? On Tue, 8 Aug 2006 07:48:01 -07...

If Then Else
Private Sub SiScode_AfterUpdate() If Me.Indicator.Value <> 0 Then _ GoTo LeaveSub Else _ MsgBox "You MUST select whether you are adding to VMI or billing CD before proceeding", , "PAY ATTENTION!" End If ' This is "END IF #1" If (Me.Dirty = True) Then ' Clear it Me.Undo End If Me.SiScode.SetFocus LeaveSub: End If ' This is "END IF #2" End Sub I originally made the mistake of placing the END IF #2 and got a compile error referencing block if issue. Searched the group and felt that I found the ans...

how do I setup my Outlook profile on someone else's desktop?
I have recently been employed by a new company. I am working at the prior staff person's desktop. I have been issued a new outlook user id. My problem is that since I am using someone else desktop, I don't know how to receive e-mails to my outlook profile, and how to incorporate or forward my predecessors e-mails with my profile. Need advise. Ivan ibvalle <ibvalle@discussions.microsoft.com> wrote: > I have recently been employed by a new company. I am working at the > prior staff person's desktop. I have been issued a new outlook user > id. My problem i...

IF without ELSE
Is it possible to use the IF function without an else clause? I have a cells that automatically update for an external source, I'd like to validate that the value is a number before passing it on via DDE. I.e. A1 = 100 B1 = IF(ISNUMBER(A1),A1,do nothing) -- B1 = IF(ISNUMBER(A1),A1,B1) causes a circular reference. Thanks have you tried IF(ISNUMBER(A1),A1,"") -- Don Guillett SalesAid Software donaldb@281.com <avian2@gmail.com> wrote in message news:1125340321.415562.279710@f14g2000cwb.googlegroups.com... > Is it possible to use the IF function without an else cla...

COUNTIF or something else?
I am trying to use COUNTIF function where the range might vary. For instance, I want to know how many yes I have in column D and E together, with the condition that C will be only equal with 1. C D E 1 1 Yes 1 Yes 1 2 Yes 2 2 Yes 3 Yes 3 Yes 3 Yes 3 {=COUNTIF(IF($C$1:$C$11=1,$D$1:$E$11,0),"yes”)} should be 2. Thanks for your help. Hi This should do it: =SUMPRODUCT(--(C1:C11=1),--(D1:D11="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes")) Regards, Per "Count-Adi" <Count-Adi@discussions.microsoft.com> sk...

Budget Category for "Everything Else"
So I recently got around to setting up a budget in Money. When I was finished, Money kindly let me know that I will have $x available to save or spend at the end of each month. What I'd like to do is now track how much of that $x I'm spending on all other non-budgeted categories each month. For many categories it's hard to budget exactly how much I'm going to spend each month (new suit vs new LCD monitor vs new coffee table vs Red Sox playoff tickets - hard to say). I'd like to keep track of how much I'm spending in total across all these unbudgeted catego...

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....