Excel Masters - How to?

[Swami]

I want to create an IF statement that does the following.

If the number of users of a program is between 100,001 & 200,00, then display 1
If the number of users of a program is between 200,001 & 300,00, then display 2

And so on and so forth to infinity.

I feel like I'm a bull in a china shop here and any help in not breaking the china would be appreciated.

(yes, I saw the Mythbusters where this myth was busted but I love the analogy).

 

[Tanked]

Excel has an if, then, else function.


=if(logical test, value if true, value if false)

Can only be nested so many times.

Dunno how you're going to do it to infinity though.


Probably easier to use a VB Macro.

 

[Skibbi9]

Excel has an if, then, else function.


=if(logical test, value if true, value if false)

Can only be nested so many times.

Dunno how you're going to do it to infinity though.


Probably easier to use a VB Macro.

or a vlookup to an array

you could divide and round and compare to a seperate table

 

[Eggi]

sounds like you could just do:

=int((cell-1)/100000);

 

[Swami]

Thanks for the insight, I was able to work-around it and think my model works...

 

[turdburgler]

vlookup would be easier

 

[reZolut]

sounds like you could just do:

=int((cell-1)/100000);

that or something like:

=left(cell, 1)

ed: you may want to add an if to that to account for <100000 users

 

[Noodles]

Seriously, just divide.