Skip to main content

Hi,

Hopefully someone has the solution for my issue: the total score (‘Score 1’) in my form must be translated into a letter grade according to the outcome. If the outcome is less than 1.99, it becomes an A; less than 3.00, a B; less than 4.00, a C; greater than 5.00, a D; and greater than 5.00, an E. What is a possible formula if the total score data label is 'Score 2' and the letter data labels are 'A', 'B', 'C', 'D', 'E'?

Txs for your help! 

Have you try if function?

https://support.docusign.com/s/document-item?language=en_US&rsc_301&bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus

How to use the if function

The if function can perform a logical test and return one numeric value for a TRUE result, and another for a FALSE result. You can specify the result values in the formula, or reference other numeric fields in the document. 

For example, you compare two numeric fields:

if (Number1 > Number2, 1, 0). 

If the expression is true, then the formula result is "1". If the express is false, then the formula result is "0".

You can also use numeric fields for the results. For example, you have four numeric fields that are filled in by your signer. You compare the first two and use the last two as the results:

if (Number1 > Number2, Number3, Number4)

 

FreeLink/甫连信息
🌍 DocuSign Partner | Partner Profile
🌟 The only DocuSign Partner globally certified as both a Certified eSignature Administrator and eSignature Technical Consultant
🏆 DocuSign 2024 APAC Reseller Growth Partner of the Year
💡 Ranked #1 in the OG All Star category in DocuSign Community Wrapped 2024
📊 DocuSign Community Leaderboard Top 5 contributor
🚀 Expertise in DocuSign integrations with on-premises systems for leading enterprises across various industries
🔗 Connect with me on LinkedInhttps://www.linkedin.com/in/gehengfeng/


Hi,

I already encountered this page and it helps till a certain point. I will keep on trying😉! Txs for your reaction. 


Hello ​@hurbster,

How are you? I hope you are doing well. I want to confirm if you need further assistance, feel free to let me know and I will gladly help you address the situation as soon as possible. Thank you!

 

Best regards,

Melanie | Docusign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue.


Reply