Good morning,

I have cells A1 and B1. Cell A1 has a value "APPLE" and a define name
"APPLE1", and Cell B1 has a numeric value 1.

Is it possible to write a formula to use define name vs. regular cell
reference (A1)?

For example, if a value in Cell B1 is 0, use regular cell reference (A1); if
a value in Cell B1 is not 0, us define name "APPLE1" for Cell A1. I want to
have the value ("APPLE") in Cell A1 stays the same.

Can it be done through Define Name area (Insert|Name|Define)?

Thanks.