Sorry for the confusing title.

We have a calculation that always worked in the past. But this is the first time we need to multiply by 10 and notice it doesn't work. In short, we want to multiply hours worked by a rate ($250). Here is what we have;

If ( Additional DJ Hours < "3" ; 750 ; Additional DJ Hours * 250)

[which should mean, if the hours are less than 3, charge $750. Otherwise, take "Additional DJ Hours" and multiply that by $250]

Additional DJ Hours field information uses a value list which basically consists of numbers 0 - 20.

When we select anything above 9, it gives us $750.

What am I missing?

Thank you!

Get rid of the quotes and make sure that your data is of type number in that field and not text.

"3" > "1000000"

is a true statement.

3 > 10

is not.