Struggling with formula that requires if statement

Hi guys,
Great plugin. I am trying to figure out a solution to my current calculated form.
I have the current formula working in my form.
(fieldname3*fieldname10)+(fieldname1+fieldname6+fieldname8+fieldname12)
This works great. What I want to achieve is an if statement on the first part of the formula.
Fieldname3 is where user enters purchase price of a house property.
Fieldname10 is a dropdown set with the following options.< £125,000 = 0%
> £125,000 < £250,000 = 1%
> £250,000 < £500,000 = 3%
> £500,000 < £1,000,000 = 4%
> £1,000,000 < £2,000,000 = 5%
> £2,000,000 = 7%I would like to do a formula whereby I can remove these options from the user side and the calculation works when the user enters the house value in Fieldname3. Is this possible? If so could somebody help me out??
So it would be
if ((fieldname3 < £125,000) * 0.00) +(fieldname1+fieldname6+fieldname8+fieldname12) and so on to cover the other %.
If anybody could help me it would be most appreciated.
Thanks
Dan
 The topic ‘Struggling with formula that requires if statement’ is closed to new replies.