![]() I'll explain a little why the 2 formulas you have don't work: ![]() Or is it when C21 is ""Lifetime C" and F11 is that it has an error? if so, try: for error to show when C21 is "Lifetime C" & F11 is blank, try: i suppose "Lifetime C" & "Lifetime F" are shortforms? your formula suggest a longer text. ![]() I have also tried 'dumbing down' the logic to meet only one condition in cell C21 and that didn't work either.Īppreciate in advance any assistance anyone can give. I tried this and other formuals but none seem to work: =and(f11datevalue(""),or(C21="Lifetime D & O Commercial",c21="Lifetime D & O Financial)) When cell I26 is selected for input I want an error message to display when one of either two conditions are met in cell C21 (in this case "Lifetime C", or 'Lifetime F"), and when cell F11 does not equal a particular date. I have used IF / OR / AND statments before in general excel but the logic seems to be different in data validation custom formulas? I am trying to set a data validation rule based on one cell meeting one either of two conditions, and another cell not meeting a condition for the error message to display but I am having no luck. I am a bit stuck however with a formula and I hope someone can help me! Hi Everyone - this is my first post and it is a pleasure to now be a part of your community.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |