How to use a formula with a condition

  • Thread starter Thread starter shegre
  • Start date Start date
S

shegre

I am wondering if there is a way to use a formula based on
a condition.

Example:
When someone presses the enter key in cell E11, can I have
a formula in another cell add 1 to a number.
 
Hi
not quite sure what you're trying to achieve. Do you want a counter
which increments each time you select cell E11??
If yes this can't be done with a formula. For this you'll need an event
procedure (e.g. the selection_change event)

But if you only want a simple condition you may use the IF function.
e.g. enter this formula in B1
=IF(A1=1,"A1 is equal 1","A1 is not equal 1")
 
Back
Top