Re: Multiple If and Else if
- From: "Stevie_mac" <no.email@xxxxxxxxxx>
- Date: Mon, 2 May 2005 21:12:43 +0100
That's a good tip Bob, I didn't even realise you could list in-place (so to speak).
I'll have to remember that one!
NOTE to Andy, If you change your points scoring system, then you have to change every instance of this, If you use a
table (as in the answer I submitted) then you only change the points in the table once.
"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message news:Or4BYI1TFHA.2756@xxxxxxxxxxxxxxxxxxxxxxx
> =LOOKUP(A1,{0,5;70,15;80,14;85,14;90,13;95,12;100,10;101,8;110,7;120,5})
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Andy" <Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B3C28EDD-30B5-4834-A7D6-DC20E91FC889@xxxxxxxxxxxxxxxx
>> Hi All,
>>
>> I need some help with mulitple condtion using if and else if(If possible)
>> otherwise I am open for better ideas.
>> I have 2 columns A & B (These number are just estimated points it will be
>> changed)
>> Column A Column B
>> < 70 5 Points
>> 70-80 15 Points
>> 80-85 14 Points
>> 85-90 13 Points
>> 90-95 12 Points
>> 95-100 12 Points
>> 100 10 Points
>> 100-110 8 Points
>> 110-120 7 Points
>> >120 5 Points
>> Based on Column A, I want the formula in Column B to generate the points.
>> I hope I am not asking that cannot be done :-)
>> Please if someone can help.
>>
>> Thanks in Advance
>> AM
>>
>>
>
>
.
- Follow-Ups:
- Re: Multiple If and Else if
- From: Bob Phillips
- Re: Multiple If and Else if
- References:
- Multiple If and Else if
- From: Andy
- Re: Multiple If and Else if
- From: Bob Phillips
- Multiple If and Else if
- Prev by Date: Re: printing - creating new files on each page break
- Next by Date: Re: Formulas for telephone numbers: finding duplicates, autoformat
- Previous by thread: Re: Multiple If and Else if
- Next by thread: Re: Multiple If and Else if
- Index(es):
Relevant Pages
|
