Hello- I am working on a spreadsheet that uses a Data Validation List and a Dependent validation list. In the third column I need an If And Then statement to say If E3="WelcomeBags" And F3="FoldMaps" Then 0.0226 Else blank. I thought this would be the easiest part of the process however it will not work. I either get an error message that says there is something wrong with your formula (but does not give any help as to what) or when I play with the formula I will get a "False".

The formula I am using is IF(And(E3="WelcomeBags",F3="FoldMaps","0.0226",""))

I am unsure where I went wrong, from reading other posts the format of the formula seems correct.... Thank you in advance for any assistance!

JBeets