Hi

I'm using the following but shows as error yet if I only use a few it works
fine - what can I do to use all the cells I'm wanting? or should I be using a
completely different formula?

=IF(R5="None","0",IF(R5="Aqua BP","15",IF(R5="A/Tour
Desk",20,IF(R5="ATS",25,IF(R5="B/Free",15,IF(R5="Bris
Mark",10,IF(R5="CTM",20,IF(R5="Disc GC",20,IF(R5="GODO",20,IF(R5="GC
ticket",20,IF(R5="Infomaps",20,IF(R5="Is. Res",20,IF(R5="Last
Res",20,IF(R5="M/Cove",20,IF(R5="Marrakesh",20,IF(R5="Marriott
Actv",20,IF(R5="Navitour",10,IF(R5="Oasis TD",20,IF(R5="Oz
Horizon",10,IF(R5="Palace C",20,IF(R5="Palace
Travel",20,IF(R5="Ppans",20,IF(R5="Q.
Travel",20IF(R5="RACV",20,IF(R5="Raptis",20,IF(R5= "Redballoon",20,IF(R5="Redcliffe Trav",20,IF(R5="Rendez",25,IF(R5="Shaftons",20,IF( R5="sta",25)))