I am trying to get a true/false value from an "IF" formula...
I think I'm doing something wrong or missing something.
What I have is - I need cells "C3" and "E3" to have certain values in them so that when they both have the correct value they return a value from "L3" and if either or both of the cells don't have the correct value it returns a "0" value.
Now the big question for you is can I use the same principle to get a False value?
If "C3" and "L3" have two correct values I get a True, But if "C3" has a different value and "E3" has the correct value I need to be able to get the value from "L3".
Example: I have "C3" that has a marker in it "I", and "E3" has a month (Jan) in it, I need the value from "L3" to show in "BF3" - But if "C3" has a different marker (not "I") in it and "E3" has the same month (Jan) in it, I need "AS3" to have the value from "L3" in it and the value in "BF3" is False. (Which your previous answer corrected)