Home > Back-end >  Google Sheet ISBETWEEN doesn't recognize named range?
Google Sheet ISBETWEEN doesn't recognize named range?

Time:09-16

Column A is named "Quantity", which works in a simple formula: enter image description here

I'm getting an error when attempting to use a named range in ISBETWEEN formula: enter image description here

I verified that ISBETWEEN works when I use cell reference A2 instead of named range Quantity: enter image description here

Any thoughts how I can fix?

  • Related