How to execute formula when the cell is filled?

Asked

Viewed 64 times

-1

I want the formula HOJE to stop running when filling or pasting information into the A4 cell that is part of the data.

=SE(A3="";"";HOJE()-A3)
  • 1

    I don’t understand how your spreadsheet is organized or the meaning of ".. form TODAY to run... " but you can check if the A4 cell is not filled with: ÉCÉL.VAZIA(A4).

1 answer

0

Just use the SE() within the =SE() again, something like:

=SE(A3="";"";SE(A4="";"";HOJE()-A3))

If understood the logic is to apply the formula only if A3 and A4 are filled.

You can also simplify using the OU(), thus:

=SE(OU(A3="";A4="");"";HOJE()-A3)

That way if A3 or A4 are empty then does not execute the formula, when filling both formula will be executed

You can also do the opposite, use the E(), then the order of the arguments will change, example:

=SE(E(A3<>"";A4<>"");HOJE()-A3;"")
  • Thanks for the help!

  • @Did you solve the problem? If yes, mark the answer as correct, otherwise comment on the result. If you do not know how to read: https://pt.meta.stackoverflow.com/a/1079/3635

Browser other questions tagged

You are not signed in. Login or sign up in order to post.