Re: if statement
From: bn%$# (bn_at_discussions.microsoft.com)
Date: 10/30/04
- Next message: Gord Dibben: "Re: Adding leading zero to a number"
- Previous message: Kijana: "RE: Adding leading zero to a number"
- In reply to: RagDyeR: "Re: if statement"
- Next in thread: RagDyeR: "Re: if statement"
- Reply: RagDyeR: "Re: if statement"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 30 Oct 2004 12:19:01 -0700
Thanks, yes the MATCH works but, what does the 0 functionally do. I toyed
with changing that number in the string and I get the correct result when
changing the zero to any number.
"RagDyeR" wrote:
> Do either of these work for you?
>
> =MATCH(A1,{111,222,333,444,555,666},0)
>
> =RIGHT(A1)
>
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "bn%$#" <bn@discussions.microsoft.com> wrote in message
> news:F76113BD-1D98-4F6D-BB1F-745E98F3429B@microsoft.com...
> here is the function I'm trying to create - 1 of 6 different values can show
> up in a cell. I want to be able to have the function result be: if value
> number one is 111 then make the result value 1, if value number two is 222
> the result value is 2, if value number three is 333 then the vaule is 3,
> etc.
> There can be 6 different numbers in the target evaluation cell and I want
> to
> compare it 6 different ways and if it matches the correct value compared
> then
> the result should be a specific number. All I've been able to figure out
> so
> far is =if(cell#,111,1). Excel looks at it as a true false statement, but
> I
> can't get it to string together more than the one comparison.
>
>
>
- Next message: Gord Dibben: "Re: Adding leading zero to a number"
- Previous message: Kijana: "RE: Adding leading zero to a number"
- In reply to: RagDyeR: "Re: if statement"
- Next in thread: RagDyeR: "Re: if statement"
- Reply: RagDyeR: "Re: if statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
