Help with a formula that's too long

Help with a formula that's too long

Hello,


You've previously helped me with this formula, but I just realized that it is too long, and Zoho won't allow me to save it as is. Could you help me figure out how to shorten it? 

The format for the formula is as follows:

Custom field A,input field: Potentials.Total Contract Value. This is a formula field that outputs currency, with the following syntax: If(Contains(${Potentials.Contract Term},'12 months'),(${Potentials.Full 1st Year Revenue}*1),If(Contains(${Potentials.Contract Term},'24 months'),(${Potentials.Full 1st Year Revenue}*2),If(Contains(${Potentials.Contract Term},'36 months'),(${Potentials.Full 1st Year Revenue}*3),If(Contains(${Potentials.Contract Term},'48 months'),(${Potentials.Full 1st Year Revenue}*4),If(Contains(${Potentials.Contract Term},'60 months'),(${Potentials.Full 1st Year Revenue}*5),If(Or(Contains(${Potentials.Contract Term},'6'),Contains(${Potentials.Contract Term},'7'),Contains(${Potentials.Contract Term},'8'),Contains(${Potentials.Contract Term},'9'),Contains(${Potentials.Contract Term},'10'),Contains(${Potentials.Contract Term},'1'),Contains(${Potentials.Contract Term},'2'),Contains(${Potentials.Contract Term},'3'),Contains(${Potentials.Contract Term},'4'),Contains(${Potentials.Contract Term},'5'),Contains(${Potentials.Contract Term},'11')),${Potentials.Full 1st Year Revenue},0))))))

Custom field B, input field: Potentials.Field Contributions (%). This is just a number field.

Custom field C, output field: Total Contract Field Contributions. This will be a formula field that will display currency. It will be derived with this expression (Field A*(Field B/100))=Field C

The final formula looks like this, but again it's too long, about 1026 characters:

(If(Contains(${Potentials.Contract Term},'12 months'),(${Potentials.Full 1st Year Revenue}*1),If(Contains(${Potentials.Contract Term},'24 months'),(${Potentials.Full 1st Year Revenue}*2),If(Contains(${Potentials.Contract Term},'36 months'),(${Potentials.Full 1st Year Revenue}*3),If(Contains(${Potentials.Contract Term},'48 months'),(${Potentials.Full 1st Year Revenue}*4),If(Contains(${Potentials.Contract Term},'60 months'),(${Potentials.Full 1st Year Revenue}*5),If(Or(Contains(${Potentials.Contract Term},'6'),Contains(${Potentials.Contract Term},'7'),Contains(${Potentials.Contract Term},'8'),Contains(${Potentials.Contract Term},'9'),Contains(${Potentials.Contract Term},'10'),Contains(${Potentials.Contract Term},'1'),Contains(${Potentials.Contract Term},'2'),Contains(${Potentials.Contract Term},'3'),Contains(${Potentials.Contract Term},'4'),Contains(${Potentials.Contract Term},'5'),Contains(${Potentials.Contract Term},'11')),${Potentials.Full 1st Year Revenue},0))))))*(${Potentials.Field Contributions (%)}/100))

 

Thanks,


Linda