Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using IF
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))) |