Thread: [Solved] If formula (2 ifs) works alone, but not together
View Single Post
 
Old 11-07-2025, 02:42 AM
JanFr JanFr is offline Windows 10 Office 2021
Novice
  
Join Date: Sep 2025
Location: Hanover
Posts: 6
JanFr is on a distinguished road
Default
Unfortunately there is one Exception, I couldn't solve... for the most I have adjusted the nice formular....but does not work with: see attached file
could you please check? It's in Cell E26.

=WENNFEHLER((INDEX(TEXTTEILEN(GLÄTTEN(INDEX(TEXTTE ILEN(E26;{"PK"."PKR"."PKF"."AV"});2));{" "."-""("")"});1))*1;0), but this one I've adjusted is not correct...;-(
Attached Files
File Type: xlsx MSOfficeForums_Test1.xlsx (13.6 KB, 2 views)
Last edited by JanFr; 11-07-2025 at 02:53 AM. Reason: more Information
Reply With Quote