I am using the developer edition and my question is regarding adding multiple If statements to formulas within an object.
I am trying to write a formula to assign a value to certain feilds so I can create a score for each account and rate them base on the score.
For example, one of the creiteria for the score is a feild name, "Number of properties" which happens to be 30 I want to assign a score of 25.
using if : IF(logical_test, value_if_true, value_if_false)
Heres what i got so far:
IF((number_of_property__c <= 5), 5, 0)
IF((5 < number_of_property__c) <= 10), 10, 0)
IF((10 < number_of_property__c) <= 20),15, 0)
IF((20 < number_of_property__c) <= 30),20, 0)
IF((30 < number_of_property__c)),25, 0)
i keep getting a "Error: Syntax error. Extra IF" on the second IF on line 2
if there is a better way to do this or if you know why im getting this error please let me know anything helps