Set value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 22 Sep 2005 00:34 GMT

Okay so heres what my workbook does thus far. I set the value in e3 by
looking up the text in b3 in a table array on the second sheet. I
would like to put this value in d3 if it is not zero. If it is zero I
want the user to be able to enter something into cell d3. But I don't
want the user to delete the formula in d3 so I would like to put it in
f3. Is this possible, or is there an easier way? Am I just over
thinking?

Reply to this Message

Gary''s Student - 22 Sep 2005 00:50 GMT

You are right on the mark!

In D3 put:

=IF((E3=0),F3,E3)

So it's use E3 unless its zero. Then use F3

Signature

Gary''s Student

> Okay so heres what my workbook does thus far. I set the value in e3 by
> looking up the text in b3 in a table array on the second sheet. I
[quoted text clipped - 3 lines]
> f3. Is this possible, or is there an easier way? Am I just over
> thinking?

Reply to this Message

Jason - 22 Sep 2005 02:08 GMT

I know that I could do that, but that requires the user of the
woorkbook to delete the formula. I would like the formula itself to be
in f3 and when e3 is zero the value in d3 will be user entered.

Reply to this Message