would you mind if I gave you an example?

"Gary''s Student" wrote:

For example, we want a cell to have either the value in B1 or C1 depending
upon A1:

=IF(AA1=1,B1,C1)
--
Gary''s Student - gsnu200752


"happy" wrote:

Is there anyway to set up one cell for different variables?