Forum menu
Topic starter
Hello,
I have forgotten all about nested formulae, what's wrong with this?
=IF(AND(L16>"0",L16<="10"),"9.74"),IF(AND(L16>"11",L16<="35"),"10.25"),IF(AND(L16>"36",L16<="168"),"10.56","")))
Posted : 21/06/2012 10:31 pm
Numbers shouldn't be in quotes?
Posted : 21/06/2012 10:33 pm
Dunno about the formula, but you've got parentheses mismatch.
Consider:
=IF(AND(L16>"0",L16<="10"),"9.74"),
IF(AND(L16>"11",L16<="35"),"10.25"),
IF(AND(L16>"36",L16<="168"),"10.56","")))
Posted : 21/06/2012 10:33 pm
Topic starter
Ok, tried this and still no luck:
=IF(AND(L16>=0,L16<=10),"9.74"),IF(AND(L16>=11,L16<=35),"10.25"),IF(AND(L16>=36,L16<=168),"10.56","")))
Posted : 21/06/2012 10:38 pm
Greater than and less than then the number. Both in quotes.
"<10"
Posted : 21/06/2012 10:40 pm
Topic starter
Sorted:
=IF(AND(L16>=0,L16<=10),"9.74",IF(AND(L16>=11,L16<=35),"10.25",IF(AND(L16>=36,L16<=168),"10.56","")))
Posted : 21/06/2012 10:47 pm
Topic starter
Thank you 🙂
Posted : 21/06/2012 11:12 pm