Formula to determine IF a value has a specific number inside it

This will highlight if the number contains 6 and 9:

Formula:

Please Login or Register  to view this content.

However, I'm not sure what you want to do about it. You could, if it were true, set the 6 to 5 or 7 and/or set the 9 to 0. Not sure what that does to, or says about, your estimate.

Regards, TMS

With your example, $1,467,093, changing the 6 to a 5 or 7 would be minus or plus $10,000. What if it were $1,647,093? Changing the 6 to a 5 or 7 would be minus or plus $100,000.

And that's exactly what that formula does. It returns True or False. You can use that as it is, or in an IF statement, or in Conditional Formatting.

See the example workbook attached.

Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Originally Posted by TMS

Not sure what that does to, or says about, your estimate.

This made me LOL.

What made me laugh was ...

My boss is a superstitious man and never ever wants me to put together a bid where the grand total or sub-totals are values that contain both a 6 and a 9.