Insert=Name=Define

Name: MyCell

RefersTo:
=INDIRECT(IF(OR(Sheet1!$F$3="BD",Sheet1!$F$3="CD") ,"Sheet1!B6","sheet1!C6"))

then in your formula (for example)

=(21^mycell+mycell)/(3+rnd()*mycell)

--
Regards,
Tom Ogilvy


"100pinesfarm" wrote:

tom,
could you give an example
Nick

"Tom Ogilvy" wrote:

possibly use a defined name with a formula to determine which cell to return.

this might be practical for a small number of formulas.

--
Regards,
Tom Ogilvy


"100pinesfarm" wrote:

example:
IF(OR(F3="BD",F3="CD"),B6,C6)

if cell "F3" is a certain value my formula requires different cell values,
this may occur numerous times in a formula, so I would like to have a shorter
way to say it.
"F3" has a limited (@4) different possibilities, but the "OR" combinations &
the goto's are quite numerous.
Thanks for any help!
Nick