Creating a calculated field that displays a text message if a certain data range is met.

[OmahaOmaha]

Hi All,

I need to create a project level calculated field to display a text message, if the data range falls within a certain range ie between 50-100% display text "Yes" if less than 50% display text "No". I also need to apply  an 'IF' filter in the field that makes sure the field is only working on projects with the project statuses of In Progress or Complete.

[OmahaOmaha]

this is my current basic code that isn't working to display the text field I want: IF({sourceField} >= 50 AND {sourceField} <= 100, "Yes", "No")

[OmahaOmaha]

Here's my updated code that works: 

IF({DE:Source Field} < 50,"Less Than 50%","50% Complete").  Need to figure out had to add the project status as a parameter in this field.

[Madalyn_Destafney]

Hi there, try this (may have to tweak the parenths):

IF({status}="CUR","CPL"),IF({DE:Source Field}<50,"Less Than 50%","50% Complete")