If Statements

[fishtalks]

i am trying to a formula for the following:

If the A1 value is 25K or less, -> 1/2 weeks; If the IO value is 25K to 150K -> 1/week; if the IO value is 150K or more -> 2/week

Any idea how i can solve this?

Thanks!

 

[VoG]

Is it?

=LOOKUP(A1,{0,25000,150000},{0.5,1,2})

 

[Scott Huish]

=LOOKUP(A1,{0,25000,150000},{"1/2 Weeks","1/week","2/week"})

 

[Jonmo1]

Welcome to the board...

Try

=LOOKUP(A1,{0,25001,150001},{"1/2","1/","2/"})&"weeks"

Hope that helps.

 

[fishtalks]

Thanks so much everybody!! the formula worked. this was very helpful.