Tag Info

Hot answers tagged

2

You cannot use it as a number. You have to "convert" your value to numeric in order to make the validation, otherwise it will be "false". You can use the VALUE function to convert a text representation of a number, or simply add a number to your value to get it interpreted as numeric. =IF([ChoiceField1]+0<=2, 0, {nested IF if false}) or ...


1

="<div><img src='/xx/xxx/PublishingImages/" &IF(OR[Employees Submitted On Time PP1]="Yes" ,"anchor.jpg', [Employees Submitted On Time PP1]="No" ,"red-no.jpg'> ","hyphen.jpg'>")&"</div>" All I did was copy your Formula and added some line breaks to see where you put all the " That is where you are going wrong " quotes ...



Only top voted, non community-wiki answers of a minimum length are eligible