Hello All,
I am trying to test a range of values in a cell:
if(and("a1" is 0 to 10, "Jack"), if("a1" is 10001 to 11000, "Jim), if("a1" is 11000 to 12000, "Joe')
Can anyone give me the correct systax or any other way to test this?
Thank you
Syed
Hello All,
I am trying to test a range of values in a cell:
if(and("a1" is 0 to 10, "Jack"), if("a1" is 10001 to 11000, "Jim), if("a1" is 11000 to 12000, "Joe')
Can anyone give me the correct systax or any other way to test this?
Thank you
Syed
Better to invoke a LOOKUP formula, something like:
=LOOKUP(A1,{0,2.229E-308,11,10001,11000},{"","Jack","","Jim","Joe"})
saziz wrote:
> Hello All,
> I am trying to test a range of values in a cell:
>
> if(and("a1" is 0 to 10, "Jack"), if("a1" is 10001 to 11000, "Jim),
> if("a1" is 11000 to 12000, "Joe')
>
> Can anyone give me the correct systax or any other way to test this?
> Thank you
> Syed
>
>
One way:
=IF(AND(A1>=0,A1<=10),"Jack",IF(AND(A1>=10001,A1<=11000),"Jim",IF(AND(A1>=11
001,A1<=12000),"Joe","No Match")))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"saziz" <[email protected]> wrote in
message news:[email protected]...
>
> Hello All,
> I am trying to test a range of values in a cell:
>
> if(and("a1" is 0 to 10, "Jack"), if("a1" is 10001 to 11000, "Jim),
> if("a1" is 11000 to 12000, "Joe')
>
> Can anyone give me the correct systax or any other way to test this?
> Thank you
> Syed
>
>
> --
> saziz
> ------------------------------------------------------------------------
> saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
> View this thread: http://www.excelforum.com/showthread...hreadid=475212
>
Thank you Aladin & RD.
Syed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks