Prev: Download link ok?
Next: Control Data Entry - push entry to next cell
From: Don on 7 Jul 2008 11:18
Hi,

If I have a rule in (say) cell B2 to deliver a a specific piece of
information, how would I consider composing an alternate rule that displays
the content of another cell aligned with it eg if(ruleB2=TRUE) then display
contents of C2 ...

Does that make sense ;(

Don-
From: edvwvw via OfficeKB.com on 7 Jul 2008 11:38
If ( rule B2 = True,C2,"something else")

Don wrote:
>Hi,
>
>If I have a rule in (say) cell B2 to deliver a a specific piece of
>information, how would I consider composing an alternate rule that displays
>the content of another cell aligned with it eg if(ruleB2=TRUE) then display
>contents of C2 ...
>
>Does that make sense ;(
>
>Don-

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200807/1

From: Max on 7 Jul 2008 11:45
Maybe you meant to do this?
In say, E2: =INDEX(C:C,MATCH(B2,D:D,0))
E2 returns the corresponding value in col C where B2 is first found in col D
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Don" wrote:
> If I have a rule in (say) cell B2 to deliver a a specific piece of
> information, how would I consider composing an alternate rule that displays
> the content of another cell aligned with it eg if(ruleB2=TRUE) then display
> contents of C2 ...
>
> Does that make sense ;(
>
> Don-
From: "David Biddulph" groups [at] on 7 Jul 2008 11:56
=IF(B2=TRUE,C2,"whatever you want if B2 is FALSE") or merely
=IF(B2,C2,"whatever you want if B2 is FALSE")
--
David Biddulph

"Don" <Don(a)discussions.microsoft.com> wrote in message
news:E90157E3-44F7-4EA2-A3A3-7D442EC1D9A8(a)microsoft.com...
> Hi,
>
> If I have a rule in (say) cell B2 to deliver a a specific piece of
> information, how would I consider composing an alternate rule that
> displays
> the content of another cell aligned with it eg if(ruleB2=TRUE) then
> display
> contents of C2 ...
>
> Does that make sense ;(
>
> Don-


 | 
Pages: 1
Prev: Download link ok?
Next: Control Data Entry - push entry to next cell