Forum Discussion
#NAME? error from nested formula
I keep getting a #NAME? error any time I input any number greater than 6 in cell A1 from the following nested IFAND formula. = IF(AND(A1>0, A1<=3), "5", IF(AND(A1>3, A1<=6), "10", IF(AND(A1>6, A...
Your formula uses curly quotes instead of straight quotes around 15 and 20. Change them to straight quotes.
By the way, do you need the quotes at all? It appears to me that you want to return numbers, not text strings.
Most probably that's apostrophes around 15 and 20, change on "normal" ones
=IF(AND(A1>0, A1<=3), "5",
IF(AND(A1>3, A1<=6), "10",
IF(AND(A1>6, A1<=9), "15",
IF(AND(A1>9, A1<=12), "20",0))))
