Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...

Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...

Hi

Can you give us an example so I can help you?

Leung



"Irfan Khan" wrote:

Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...

Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12



Now if Erlang is between 0 and 0.3 then I need TRX=1, then if ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...

"Pete_UK" wrote:

Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...

Set up a table like this somewhere on your sheet:

0.0 1
0.3 2
5.1 3
10.7 4
17.6 5
23.8 6
31.0 7
37.5 8
45.0 9
51.6 10
59.2 11
65.9 12

Let's say this occupies cells M1:N12. Then with your calculated
Erlangs in A2 (say), you can use this formula to return the number of
lines:

=VLOOKUP(A2,M$1:N$12,2)

Adjust the cell references to suit.

Hope this helps.

Pete

On Nov 7, 10:18 am, Irfan Khan
wrote:
Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12

Now if Erlang is between 0 and 0.3 then I need TRX=1, then if ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...



"Pete_UK" wrote:
Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...- Hide quoted text -

- Show quoted text -

Hi,

Thanks for the solution but I have already tried this... problem is vlookup
is not giving reults as i need coz it wont give reults with "Between"
comparisons...


"Pete_UK" wrote:

Set up a table like this somewhere on your sheet:

0.0 1
0.3 2
5.1 3
10.7 4
17.6 5
23.8 6
31.0 7
37.5 8
45.0 9
51.6 10
59.2 11
65.9 12

Let's say this occupies cells M1:N12. Then with your calculated
Erlangs in A2 (say), you can use this formula to return the number of
lines:

=VLOOKUP(A2,M$1:N$12,2)

Adjust the cell references to suit.

Hope this helps.

Pete

On Nov 7, 10:18 am, Irfan Khan
wrote:
Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12

Now if Erlang is between 0 and 0.3 then I need TRX=1, then if ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...



"Pete_UK" wrote:
Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...- Hide quoted text -

- Show quoted text -

If you had a value of 2.5, say, then the formula I gave you will
return 2, or a value of 18.7 will return 5 - is this not what you
want?

Maybe you are thinking that VLOOKUP is looking for an exact match, but
I have not set the 4th parameter in the function so it does not
operate that way in my formula.

Pete

On Nov 7, 1:08 pm, Irfan Khan
wrote:
Hi,

Thanks for the solution but I have already tried this... problem is vlookup
is not giving reults as i need coz it wont give reults with "Between"
comparisons...



"Pete_UK" wrote:
Set up a table like this somewhere on your sheet:

0.0 1
0.3 2
5.1 3
10.7 4
17.6 5
23.8 6
31.0 7
37.5 8
45.0 9
51.6 10
59.2 11
65.9 12

Let's say this occupies cells M1:N12. Then with your calculated
Erlangs in A2 (say), you can use this formula to return the number of
lines:

=VLOOKUP(A2,M$1:N$12,2)

Adjust the cell references to suit.

Hope this helps.

Pete

On Nov 7, 10:18 am, Irfan Khan
wrote:
Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12

Now if Erlang is between 0 and 0.3 then I need TRX=1, then if ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...

"Pete_UK" wrote:
Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

For nearest range comparison, you should put the 4th paramter to "true".



"Pete_UK" wrote:

If you had a value of 2.5, say, then the formula I gave you will
return 2, or a value of 18.7 will return 5 - is this not what you
want?

Maybe you are thinking that VLOOKUP is looking for an exact match, but
I have not set the 4th parameter in the function so it does not
operate that way in my formula.

Pete

On Nov 7, 1:08 pm, Irfan Khan
wrote:
Hi,

Thanks for the solution but I have already tried this... problem is vlookup
is not giving reults as i need coz it wont give reults with "Between"
comparisons...



"Pete_UK" wrote:
Set up a table like this somewhere on your sheet:

0.0 1
0.3 2
5.1 3
10.7 4
17.6 5
23.8 6
31.0 7
37.5 8
45.0 9
51.6 10
59.2 11
65.9 12

Let's say this occupies cells M1:N12. Then with your calculated
Erlangs in A2 (say), you can use this formula to return the number of
lines:

=VLOOKUP(A2,M$1:N$12,2)

Adjust the cell references to suit.

Hope this helps.

Pete

On Nov 7, 10:18 am, Irfan Khan
wrote:
Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12

Now if Erlang is between 0 and 0.3 then I need TRX=1, then if ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...

"Pete_UK" wrote:
Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Or omit it, as it defaults to TRUE if missing.

Pete

On Nov 7, 4:07 pm, Leung wrote:
For nearest range comparison, you should put the 4th paramter to "true".



"Pete_UK" wrote:
If you had a value of 2.5, say, then the formula I gave you will
return 2, or a value of 18.7 will return 5 - is this not what you
want?

Maybe you are thinking that VLOOKUP is looking for an exact match, but
I have not set the 4th parameter in the function so it does not
operate that way in my formula.

Pete

On Nov 7, 1:08 pm, Irfan Khan
wrote:
Hi,

Thanks for the solution but I have already tried this... problem is vlookup
is not giving reults as i need coz it wont give reults with "Between"
comparisons...

"Pete_UK" wrote:
Set up a table like this somewhere on your sheet:

0.0 1
0.3 2
5.1 3
10.7 4
17.6 5
23.8 6
31.0 7
37.5 8
45.0 9
51.6 10
59.2 11
65.9 12

Let's say this occupies cells M1:N12. Then with your calculated
Erlangs in A2 (say), you can use this formula to return the number of
lines:

=VLOOKUP(A2,M$1:N$12,2)

Adjust the cell references to suit.

Hope this helps.

Pete

On Nov 7, 10:18 am, Irfan Khan
wrote:
Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12

Now if Erlang is between 0 and 0.3 then I need TRX=1, then if ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...

"Pete_UK" wrote:
Could you rephrase this? I don't understand what you are asking.

Pete

On Nov 7, 9:58 am, Irfan Khan
wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have Switch or
between functions in excel...- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Or use 1


--


Regards,


Peo Sjoblom


"Pete_UK" wrote in message
ps.com...
Or omit it, as it defaults to TRUE if missing.

Pete

On Nov 7, 4:07 pm, Leung wrote:
For nearest range comparison, you should put the 4th paramter to "true".



"Pete_UK" wrote:
If you had a value of 2.5, say, then the formula I gave you will
return 2, or a value of 18.7 will return 5 - is this not what you
want?

Maybe you are thinking that VLOOKUP is looking for an exact match, but
I have not set the 4th parameter in the function so it does not
operate that way in my formula.

Pete

On Nov 7, 1:08 pm, Irfan Khan
wrote:
Hi,

Thanks for the solution but I have already tried this... problem is
vlookup
is not giving reults as i need coz it wont give reults with "Between"
comparisons...

"Pete_UK" wrote:
Set up a table like this somewhere on your sheet:

0.0 1
0.3 2
5.1 3
10.7 4
17.6 5
23.8 6
31.0 7
37.5 8
45.0 9
51.6 10
59.2 11
65.9 12

Let's say this occupies cells M1:N12. Then with your calculated
Erlangs in A2 (say), you can use this formula to return the number
of
lines:

=VLOOKUP(A2,M$1:N$12,2)

Adjust the cell references to suit.

Hope this helps.

Pete

On Nov 7, 10:18 am, Irfan Khan

wrote:
Like i am having following table -

Region TCH ErLang TRX
BLR 2 0.3 1
BLR 10 5.1 2
BLR 17 10.7 3
BLR 25 17.6 4
BLR 32 23.8 5
BLR 40 31.0 6
BLR 47 37.5 7
BLR 55 45.0 8
BLR 62 51.6 9
BLR 70 59.2 10
BLR 77 65.9 11
BLR 85 73.5 12

Now if Erlang is between 0 and 0.3 then I need TRX=1, then if
ErLang is 0.3
and <5.1 then TRX=2. I hope now i make some understanding...

"Pete_UK" wrote:
Could you rephrase this? I don't understand what you are
asking.

Pete

On Nov 7, 9:58 am, Irfan Khan

wrote:
Hi All,

I am having multiple IF conditions in excel2003, Can I have
Switch or
between functions in excel...- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -