Forum Discussion
Formula Editor
Hi Everybody, currently, I am developing a tool for a client for company controlling purposes. My formulas are getting longer and longer. Now, I have spent more than two hours looking for a c...
I'm not sure what exactly is required. but send this link ... maybe it will help. If not, just ignore it.
Erstellen benutzerdefinierter Funktionen in Excel
https://support.microsoft.com/de-de/office/erstellen-benutzerdefinierter-funktionen-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f
Nikolino
I know I don't know anything (Socrates)
Hi,
thanks for your reply. I was looking for a tool that would make
=WENNFEHLER(WENN(AF6="H";(INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6)*-1);INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6));"")
readable like
=WENNFEHLER(
WENN(AF6="H";(
INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6)*-1);
INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6))
;"")
Maybe that explains it a litte bit better.