• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add onto existing formula IF does not contain "text" then apply a different calculation


I have figured out half of the formula, but I've been unable to add figure out the last criteria based on text, that if it contains "Text" do a different calculation.

I am perplexed that we pay for a system i.e. Payroll, and yet at the end of the day it still comes down to excel ninja's.

Thank you, I would be lost without each and everyone of you!



A huge big thank you to All, you all make it looks so easy. I'm not sure why I don't approach my formulas with a more simple approach.

Take care, Kelli