Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 160
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello I have a list of items where there is a price difference. But I want to remove items that have a change of 5% but either plus or minus. How can I write this as a formula?
So if there is a price difference if -5% or at a positive 5% and any range within that (so -5% up to 5%), how can I write the formula to remove items if they are within that range? But I want to hold anything that is day -6%. So a min of -5% and a max of 5%.
So if there is a price difference if -5% or at a positive 5% and any range within that (so -5% up to 5%), how can I write the formula to remove items if they are within that range? But I want to hold anything that is day -6%. So a min of -5% and a max of 5%.