Urgent Help Need to simplify Formula

Urgent Help Need to simplify Formula

Hi guys

Can anyone help me with reducing the number of characters in this formula for use in Formula Fields in CRM package. 
Currenlty Exceeds the 5000 character limit by some 325 characters.  Next problem is the final code will need to be three times this. Unless of course there is a way where we can create a formula where the results of Formula Fields can be added/multiply/subtract and divide each other to achieve a final figure.

((If(Contains(${WEB Single Trip Travel.Europe Number of Days},'5'),35,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'10'),42,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'17'),52.5,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'24'),61,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'31'),75,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'38'),88,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'45'),101,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'52'),114,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'59'),127,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'66'),140,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'73'),153,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'80'),166,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'87'),179,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'94'),192,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'101'),205,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'108'),218,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'115'),231,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'123'),244,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'130'),257,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'137'),270,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'144'),283,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'151'),296,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'215'),250,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'245'),260,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'275'),270,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'305'),280,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'335'),290,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'365'),305,

If(Contains(${WEB Single Trip Travel.Europe Number of Days},'none'),0,0))))))))))))))))))))))))))))))*((If((Tonumber(${WEB Single Trip Travel.Person 1 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 1 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 1 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 1 Age on Departure}))>=16,1,0))+((If((Tonumber(${WEB Single Trip Travel.Person 2 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 2 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 2 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 2 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 3 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 3 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 3 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 3 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 4 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 4 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 4 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 4 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 5 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 5 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 5 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 5 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 6 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 6 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 6 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 6 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 7 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 7 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 7 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 7 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 8 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 8 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 8 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 8 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 9 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 9 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 9 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 9 Age on Departure}))>=16,1,0)))+((If((Tonumber(${WEB Single Trip Travel.Person 10 Age on Departure}))<2,-0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 10 Age on Departure}))>69,1,0)+If((Tonumber(${WEB Single Trip Travel.Person 10 Age on Departure}))<=15,0.5,0)+If((Tonumber(${WEB Single Trip Travel.Person 10 Age on Departure}))>=16,1,0))))*(If(Contains(${WEB Single Trip Travel.Is Person 2 Partner/Spouse},'Yes'),0.75,1)))*(If(Contains(${WEB Single Trip Travel.Winter Sports},'Yes'),2,1))



Needless to say this is rather urgent.


Regards

Steve