MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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","")))
Numbers shouldn't be in quotes?
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","")))
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","")))
Greater than and less than then the number. Both in quotes.
"<10"
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","")))
Thank you 🙂