Hi there, is anyone able to assist with the code below. It largely appears to work, however, some of the uplifted values don’t work (1.2, 1.3 etc).
Any insight you can provide would be much appreciated!
Chris.
2 Likes
My apologies, code now included!
MAX(Agreed Sale Price of Property * 0.001, 500) * IF(CONTAINS(Property Type, 1), 1.2, 1) * IF(CONTAINS(Property Type, 2), 1.1, 1) * IF(CONTAINS(Property Type, 3), 1, 1) * IF(CONTAINS(Property Type, 4), 1, 1) * IF(CONTAINS(Age of Property, 1), 1.3, 1) * IF(CONTAINS(Age of Property, 2), 1.2, 1) * IF(CONTAINS(Age of Property, 3), 1.1, 1) * IF(CONTAINS(Age of Property, 4), 1, 1) * IF(CONTAINS(Bedrooms, 1), 1, 1) * IF(CONTAINS(Bedrooms, 2), 1.1, 1) * IF(CONTAINS(Bedrooms, 3), 1.2, 1) * IF(CONTAINS(Bedrooms, 4), 1.3, 1) * IF(CONTAINS(Bedrooms, 5), 1.4, 1) * IF(CONTAINS(Condition of Property, 1), 1.2, 1) * IF(CONTAINS(Condition of Property, 2), 1.1, 1) * IF(CONTAINS(Condition of Property, 3), 1, 1)
2 Likes
Hello there, @Christopher_Snape 
Could you please send me a link to the page, where your widget is installed, or just share the widget ID? I’ll be happy to check it for you 
1 Like
Hi there, it’s not on my webpage as yet, and can’t seem to find the widget ID. I’ve attached a screenshot if this helps?
2 Likes
Ah, I see, you’re testing it in demo.
Is this formula a part of the ready-made Calculator template? If so, please specify the name of the template you’ve chosen.
However, if you’ve adjusted the template and built this formula yourself, just save this widget and it will appear in your account. So, I’ll be able to check it out
1 Like
Hi, does this work:
2 Likes
Thank you!
The thing is that the options you’ve chosen in the screenshot have 0 values:
If you replace 0 values, everything should be working fine.
Please check it out and let me know if it helped
Amazing! Thanks very much.
1 Like
No sweat!
If anything else comes up, we’re always here to help 