MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
I have a column of data - numbers representing £ unit value of '000's of stock items.
I want to identify which have a £ unit value of between £200 and £1,500 - by returning a Yes on the cell to the right.
Please remind me...
Many thanks.
Posted : 17/05/2019 8:00 am
If(A1>=200,if(A1<1500,”YES”,”NO”),”NO”)
Change cell A1 to suit obvs.
Posted : 17/05/2019 8:06 am
AND(A1>=200,A1<=1500)
Posted : 17/05/2019 8:12 am
Topic starter
Thanks folks - both work just fine and dandy.
Filed for future reference.
Appreciate it.
Posted : 17/05/2019 8:17 am
If you had more bins to identify it'd get hard to follow using If() That's where Vlookup() starts to shine:
https://www.excelcampus.com/functions/vlookup-closest-match-true/
Posted : 17/05/2019 10:02 am