I would like to create a function call so that when I enter a value into a
cell a formula is executed on the number. For instance, if I enetr the
number "1" in to cell D6, the formula D6*E6 is executed. Can this be done

=IF(D6=1,D6*E6,"whatever answer you want if D6 isn't 1")

Note that "1" in quote marks is a text string, whereas 1 without quote marks
is a number.
--
David Biddulph

"pmvgoose" wrote in message
...
I would like to create a function call so that when I enter a value into a
cell a formula is executed on the number. For instance, if I enetr the
number "1" in to cell D6, the formula D6*E6 is executed. Can this be done

Maybe this

=IF(D6<"",D6*E6,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"pmvgoose" wrote:

I would like to create a function call so that when I enter a value into a
cell a formula is executed on the number. For instance, if I enetr the
number "1" in to cell D6, the formula D6*E6 is executed. Can this be done

Entering a number in D6 would erase any formula you had in D6

You can put the formula in an adjacent cell.

See other replies for formula.

If you wanted it all done in D6 you would need VBA event code.


Gord Dibben MS Excel MVP

On Fri, 29 Jan 2010 12:40:01 -0800, pmvgoose
wrote:

I would like to create a function call so that when I enter a value into a
cell a formula is executed on the number. For instance, if I enetr the
number "1" in to cell D6, the formula D6*E6 is executed. Can this be done