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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top