I am completely blanking and am now curious if I am totally imagining it.
Using Excel 2007, I thought I had used a formula with the syntax:
=XXXXX(A1<=0, “Zero”, A1<=10, “1-10”, A1>10,”11+”)
Although now I am looking thru the list of formula's and not seeing anything that jumps out at me. I was thinking maybe I am thinking of having used a Choose statement with some intermediate steps to setup an index.
I could easily do this with nested If's, but I am sure I have done something like this w/o them before and am on a mission to remember.
Anyone have any thoughts? Thanks.
Using Excel 2007, I thought I had used a formula with the syntax:
=XXXXX(A1<=0, “Zero”, A1<=10, “1-10”, A1>10,”11+”)
Although now I am looking thru the list of formula's and not seeing anything that jumps out at me. I was thinking maybe I am thinking of having used a Choose statement with some intermediate steps to setup an index.
I could easily do this with nested If's, but I am sure I have done something like this w/o them before and am on a mission to remember.
Anyone have any thoughts? Thanks.