+ Start a Discussion
Terry_0101Terry_0101 

Display a YES, if value is greater than 0

I have 5 numeric fields.  If any of those have a value greater than 0, then display a YES.
Akhil AnilAkhil Anil
Your formula will look like this if your formula field is of type Text.
 
IF(
OR(
Number_field1__c > 0,
Number_field2__c > 0,
Number_field3__c > 0,
Number_field4__c > 0,
Number_field5__c > 0
),
"YES",
"NO"
)

You can also choose to change the data type of your formula field and make it of the type checkbox with the below formula.
 
IF(
OR(
Number_field1__c > 0,
Number_field2__c > 0,
Number_field3__c > 0,
Number_field4__c > 0,
Number_field5__c > 0
),
TRUE,
FALSE
)

Use the insert field option to use the right API names of the fields.

Kindly mark it as an answer if that works !
Akhil AnilAkhil Anil
Your formula will look like this if your formula field is of type Text.
 
IF(
OR(
Number_field1__c > 0,
Number_field2__c > 0,
Number_field3__c > 0,
Number_field4__c > 0,
Number_field5__c > 0
),
"YES",
"NO"
)

You can also choose to change the data type of your formula field and make it of the type checkbox with the below formula.
 
IF(
OR(
Number_field1__c > 0,
Number_field2__c > 0,
Number_field3__c > 0,
Number_field4__c > 0,
Number_field5__c > 0
),
TRUE,
FALSE
)

Use the insert field option to use the right API names of the fields.

Kindly mark it as an answer if that works !
YogeshMoreYogeshMore
Hello Terry,
 
You can also use following formula to achieve your requirement.
IF((field1+field2+field3+field4+field5)> 0, "YES ", "NO ")

Regards,
Yogesh More
Salesforce Consultant || Salesforce Developer
 more.yogesh422@gmail.com || +919096872010
www.yogeshmore.com || Skype:-yogesh.more44
 
Amit Chaudhary 8Amit Chaudhary 8
If you want to check any value greater then zero then your formula should be like below
IF(
	OR(
		field1__c > 0,
		field2__c > 0,
		field3__c > 0,
		field4__c > 0,
		field5__c > 0
	),
	"YES",
	"NO"
)

If you want to check sum of all five field the it should be like below
IF((field1__c+field2__c+field3__C+field4__C+field5__c)> 0, "YES ", "NO ")
Let us know if this will help you