Excel

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
 
D

David Biddulph

=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.
 
M

Mike H

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.
 
G

Gord Dibben

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
 
Top