Is there a way to make this formula also measure the exact same negative numbers?
I know it sounds odd, but at the moment if there is between 5 and 19.99 in cell B2 1 point is assigned.
I need to also assign 1 point if the cell B2 has between negative 5 and negative 19.99.
This is the current formula that works for positive numbers:
=IF(AND(B2>=5,B2<=19.99),1,IF(AND(B2>=20,B2<=39.99),2,0))
Bookmarks