Calculate if different is less

[Joe1010]

I used this formula to identify the different

If ({@Diff}) >4.99 and ({@Diff}) < 10 then "5-10" else
If ({@Diff}) >9.99 and ({@Diff}) < 20 then "10-15" else
"N/A"

However, so me differences are a negative. I would like to changes the formula like this, if the diff is more display “A1” if it is less, between 0-5 display “0-5”
If it is between 5-10 less, display “5-10”

What is the formula?

Thank you

 

[synapsevampire]

Try:

If ({@Diff}) <= 4.99 then
"A1"
else
If ({@Diff}) > 4.99
and
({@Diff}) < 10 then
"5-10"
else
If ({@Diff}) >9.99
and ({@Diff}) < 20 then
"10-15"
else
"N/A"

Or change the <=4.99 to whatever is appropriate, the point is to allow for all value ranges.

-k

 

[Joe1010]

Let me clarify my problem.

If the different is more than 0, then display “Good” that means that I will make more profit.

If the Diff is less than 0, then
If it is between 0 and 5 below, then display “0-5”
If it is between 5 and 10 below, then display “5-10”

How can this be done?
Thanks