-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 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)
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 excel
You are not signed in. Login or sign up in order to post.
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)
.– anonimo