Display contents of associated cells
=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" wrote in message
...
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-
|