@BrosJr
The issue in your formula is due to the use of the OR operator (||) between the conditions.
If you want to exclude values that start with "A", "B", "D", "6", or "9", you should use the AND operator (&&) instead of OR.
The use of OR is returning true because if the first character is not "A", it's true that it's not "A" and the condition is satisfied regardless of the other checks.
Here's the corrected formula:
If(
Left(varScan, 1) <> "A" &&
Left(varScan, 1) <> "B" &&
Left(varScan, 1) <> "D" &&
Left(varScan, 1) <> "6" &&
Left(varScan, 1) <> "9",
varScan,
Parent.Default
)
This formula should check that the first character is not "A", "B", "D", "6", or "9" and only then returns varScan. If any of these conditions are not met, it returns Parent.Default.
Because you exclude (<>) you should use &&. If it were include (=), then you might use || instead
