# Scoring Formula using multiple record types

I have a field that is common to several different record types, but the way it is scored is different for each. I am looking for assistance on how to write a formula that populates the same field differently for all of the different scoring scenarios if possible.

Example: My field is called Current Ratio and it is associated with Record Type 1, Record Type 2, and Record Type 3. For RT 1, I need the formula to provide a score of '6' if the Current Ratio is > 3.00. For RT 2, I need the formula to provide a score of '6' if the Current Ratio is > 2.50. For RT 3, I need a score of '6' if the Current Ratio is > 2.00.

The formula below works as is but does not include the Record Types, but can I include the RTs into this formula without having to create separate formulas for each?

IF( Current_Ratio__c > 3.00,6, IF( Current_Ratio__c >= 2.25,5, IF( Current_Ratio__c >= 1.75,4, IF( Current_Ratio__c >= 1.25,3, IF( Current_Ratio__c >= 1.00,2, IF( Current_Ratio__c <= 1.00,1, 0))))))

Thanks in advance for any assistance or feedback!

• You should look into the `CASE` formula function. Commented May 27, 2015 at 18:52

Yes you can use the `RecordType` merge field for your object and include it in your formula. So the format would be `<Your object>.RecordType.Name` Use it with your existing IF statement or you can even use a CASE statement with your record type name.
``````IF( Current_Ratio__c && <Your object>.RecordType.Name='RT1'> 3.00,6, IF( Current_Ratio__c && <Your object>.RecordType.Name='RT2'>= 2.25,5**............**