So this is my formula:
+IF(MID(B9;{3;8};4)="A00B";$B$68)
What I want to do:
- If start from the third caracter and the 4 caracters after it are equal to "A00B", I want it to count the cell B68
- If start from the eight caracter and the 4 caracters after it are equal to "A00B", I want it to count the cell B68
I know I can make two different formulas but I want to keep it in one since I will have to use a lot.
Thanks in advance,
Bookmarks