I found the error of my ways! Just need to walk away for a bit.
I have a worksheet that shows the change in revenue per customer for a six month period as both a % and $. I want the user to input the minimum % and $ parameters. The twist is when a user inputs the minimum % and $, for example 20% and $48,000, I would like the results to include customers with <= -20% and >=20% and
<= -$48,000 and >= $48,000.
The following calculation and parameters only result in positive results, not the negative.
Below is the $ side of the calculation and parameter; not showing the %
Parameter: Enter $ Change in Six Month Sales
Calculation for $ Change in Sales:
if[Change in Six Month Sales $ ]>=[Enter $ Change in Six Month Sales] and
[Change in Six Month Sales $]<= -([Enter $ Change in Six Month Sales])
then [Change in Six Month Sales $ ] end
Message was edited by: Carol Gensimore
Please attach a sample workbook.
This should be quite straightforward to solve with a workbook to see the current calculations and parameters.