Hello,
I'm trying to write a formula that passes or fails a value.
example: The user types into a cell "ABC 123"
The ABC is a constant therefore it is just a matter of IF=(D10="ABC","pass","fail")
however the 123 must be equal to another cell (d4)
so the formula I'm trying to write looks something like IF=(D10="ABC" + D7, "pass","fail").
This does not work, any better methods?
I'm trying to write a formula that passes or fails a value.
example: The user types into a cell "ABC 123"
The ABC is a constant therefore it is just a matter of IF=(D10="ABC","pass","fail")
however the 123 must be equal to another cell (d4)
so the formula I'm trying to write looks something like IF=(D10="ABC" + D7, "pass","fail").
This does not work, any better methods?