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
```
 0
Utf
5/11/2010 12:46:01 PM
excel.programming 6508 articles. 2 followers.

5 Replies
872 Views

Similar Articles

[PageSpeed] 37

```Hi,

Well it's doing exactly what your telling it to do:

Check in turn M52, M51, M50, M49 & M48 of whatever aWs is and as soon as 1
of those tests evaluates as TRUE put a number in M80.

You must be aware that as soon as a condition has evaluated as TRUE then
none of the following tests execute

so the real question is what do you want it to do?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"pls123" wrote:

> 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
```
 0
Utf
5/11/2010 12:57:01 PM
```hi mike !!
the problem is that..
i changed the raws of sub like i showed before..
...to make it more efficient for cpu..
but it doesn't write the number !!!

before it was  without the else...
like ths..

if 48 true then 1 end if
if 49 true then 2 end if
.....etc ..etc...

i have no idea..!
paolo

"Mike H" wrote:

> Hi,
>
> Well it's doing exactly what your telling it to do:
>
> Check in turn M52, M51, M50, M49 & M48 of whatever aWs is and as soon as 1
> of those tests evaluates as TRUE put a number in M80.
>
> You must be aware that as soon as a condition has evaluated as TRUE then
> none of the following tests execute
>
> so the real question is what do you want it to do?
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "pls123" wrote:
>
> > 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
```
 0
Utf
5/11/2010 1:17:01 PM
```sorry mike there was another error !!!!!!

i have 2 different pages..
in 1 kind all those cells are empty..

realy very sorry for the disturb !
paolo

"pls123" wrote:

> hi mike !!
> the problem is that..
> i changed the raws of sub like i showed before..
> ..to make it more efficient for cpu..
> but it doesn't write the number !!!
>
> before it was  without the else...
> like ths..
>
> if 48 true then 1 end if
> if 49 true then 2 end if
> ....etc ..etc...
>
>
> i have no idea..!
> paolo
>
>
>
>
>
>
> "Mike H" wrote:
>
> > Hi,
> >
> > Well it's doing exactly what your telling it to do:
> >
> > Check in turn M52, M51, M50, M49 & M48 of whatever aWs is and as soon as 1
> > of those tests evaluates as TRUE put a number in M80.
> >
> > You must be aware that as soon as a condition has evaluated as TRUE then
> > none of the following tests execute
> >
> > so the real question is what do you want it to do?
> > --
> > Mike
> >
> > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > introduces the fewest assumptions while still sufficiently answering the
> > question.
> >
> >
> > "pls123" wrote:
> >
> > > 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
```
 0
Utf
5/11/2010 1:28:01 PM
```Hi,

> if 48 true then 1 end if
> if 49 true then 2 end if

Is a completely different structure. Doing it that that way each of the IF's
will execute even if the first was TRUE so if they are all TRUE that value in
M80 will be the result of the last if statement.

I'm no clearer on what the problem is, the code from your first post works
perfectly for me. If for example we have the following set of conditions

M52=FALSE
M51=FALSE
M50=TRUE
M49=TRUE
M48=TRUE

then the value in M80 will be 3 and M49 & M48 will not be tested. So for the
above set of conditions what result would you expect? What is Aws?
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"pls123" wrote:

> hi mike !!
> the problem is that..
> i changed the raws of sub like i showed before..
> ..to make it more efficient for cpu..
> but it doesn't write the number !!!
>
> before it was  without the else...
> like ths..
>
> if 48 true then 1 end if
> if 49 true then 2 end if
> ....etc ..etc...
>
>
> i have no idea..!
> paolo
>
>
>
>
>
>
> "Mike H" wrote:
>
> > Hi,
> >
> > Well it's doing exactly what your telling it to do:
> >
> > Check in turn M52, M51, M50, M49 & M48 of whatever aWs is and as soon as 1
> > of those tests evaluates as TRUE put a number in M80.
> >
> > You must be aware that as soon as a condition has evaluated as TRUE then
> > none of the following tests execute
> >
> > so the real question is what do you want it to do?
> > --
> > Mike
> >
> > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > introduces the fewest assumptions while still sufficiently answering the
> > question.
> >
> >
> > "pls123" wrote:
> >
> > > 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
```
 0
Utf
5/11/2010 1:29:01 PM
```i'm sorry,  i had to explain that it was correct the order so that
if 5 was true it would overwrite any other value..

it was important that if 1 2 and 3 was true it would sign 3..
so the if else should be ok starting from the more prioritarius..
so 5 !!

aws was ...

Dim aWB As Workbook
Dim aWS As Worksheet

Set aWB = ThisWorkbook
Set aWS = aWB.Worksheets(1)

the same sub runs on many worbooks at a time !!
paolo

"Mike H" wrote:

> Hi,
>
> > if 48 true then 1 end if
> > if 49 true then 2 end if
>
> Is a completely different structure. Doing it that that way each of the IF's
> will execute even if the first was TRUE so if they are all TRUE that value in
> M80 will be the result of the last if statement.
>
> I'm no clearer on what the problem is, the code from your first post works
> perfectly for me. If for example we have the following set of conditions
>
> M52=FALSE
> M51=FALSE
> M50=TRUE
> M49=TRUE
> M48=TRUE
>
> then the value in M80 will be 3 and M49 & M48 will not be tested. So for the
> above set of conditions what result would you expect? What is Aws?
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "pls123" wrote:
>
> > hi mike !!
> > the problem is that..
> > i changed the raws of sub like i showed before..
> > ..to make it more efficient for cpu..
> > but it doesn't write the number !!!
> >
> > before it was  without the else...
> > like ths..
> >
> > if 48 true then 1 end if
> > if 49 true then 2 end if
> > ....etc ..etc...
> >
> >
> > i have no idea..!
> > paolo
> >
> >
> >
> >
> >
> >
> > "Mike H" wrote:
> >
> > > Hi,
> > >
> > > Well it's doing exactly what your telling it to do:
> > >
> > > Check in turn M52, M51, M50, M49 & M48 of whatever aWs is and as soon as 1
> > > of those tests evaluates as TRUE put a number in M80.
> > >
> > > You must be aware that as soon as a condition has evaluated as TRUE then
> > > none of the following tests execute
> > >
> > > so the real question is what do you want it to do?
> > > --
> > > Mike
> > >
> > > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > > introduces the fewest assumptions while still sufficiently answering the
> > > question.
> > >
> > >
> > > "pls123" wrote:
> > >
> > > > 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
```
 0
Utf
5/11/2010 2:18:07 PM

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