|When I paste the latest formula into a cell I get #NAME.|
The formula evaluator shows the error coming from this:
As Mike noted, there are different styles of quotes in your formula and as soon as Excel encounters those backward quotes it doesn't recognize it as a text string or a number, thus you get a #NAME error.
In addition, you have repetitive clauses, unnecessary parenthesis, etc.
I broke your formula down into it's parts and pieces and if I'm not mistaken, these are your "IF's" for each result:
(Note: I'm dropping all quotes and extra parentheses)
Your final value_if_false appears to be AF2*2*93+15
That also happens to be the desired result for AND(AD2=1,AF2>.5). That's a bit confusing, but if that's what you want, OK.
So if I take all of your criteria and desired results and put them in a formula, I get this:
You will have to test it to see if you get the results you expect.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03