Similar Posts

Subscribe
Notify of
6 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
GutenTag2003
1 year ago

e.g.

=WENN(F10+(A10-B10)=0;”;F10+(A10-B10))

… in table form

=WENN(+F10+[@Input]-[@Output]=0;”;+F10+[@Input]-[@Output]

GutenTag2003
1 year ago
Reply to  dersuchende1

Copy your formula here

GutenTag2003
1 year ago

=WENN(+[@input]-[@output]+F10=0;”;+F10+[@input]-[@output]

DodgeRT
1 year ago

https://excelhero.de/functions/excelif-function/

in excel there is an if-then function. simply query if, for example, the input is empty, then it only gives a blank line