Excel

  • Thread starter Thread starter pmvgoose
  • Start date Start date
P

pmvgoose

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.
 
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
 
Back
Top