Hi there, I have a formula that works perfectly on Excel 2007 but at work we use Excel 2003! I know its very clunky but I'm no Excel pro... The problem is that Excel 2003 only allows 7 nestings in a formula, but 2007 will let me do plenty more.
=IF(B2="Left a message or voicemail",1,IF(B2="No answer, call back",2,IF(B2="No answer, wrong number",3,IF(B2="Unavailable until a later date, note details of when available",4,IF(B2="Not interested or unable to attend, note details",5,IF(B2="Would like to recieve more information via email",6,IF(B2="Would like to register at a later date via website",7,IF(B2="Interested in attending and still in discussion or may nominate a colleague",8,IF(B2="Requested website address for further details",9,IF(B2="Previously registered",10,IF(B2="Registered on the telephone now",11,IF(B2="Change of personal or company details",12,IF(B2="Do not call back, they will let us know",13,IF(B2="Other, note details",14,"Select outcome please"))))))))))))))
What it does is if it sees that a cell contains one of the conditions (such as the text "No answer, call back", it will become the relevent number), but on 2003 I can only get it working for 7 out of the 14 codes I want!
If someone could tell me how I could achieve the same thing on 2003 you'd be doing me a massive favour, I'm told the nesting problem can be overcome using VBA, but I don't really know how to do it.
If this is a bad forum to post for this kind of advice, pointing me in the right direction would also be appreciated.
=IF(B2="Left a message or voicemail",1,IF(B2="No answer, call back",2,IF(B2="No answer, wrong number",3,IF(B2="Unavailable until a later date, note details of when available",4,IF(B2="Not interested or unable to attend, note details",5,IF(B2="Would like to recieve more information via email",6,IF(B2="Would like to register at a later date via website",7,IF(B2="Interested in attending and still in discussion or may nominate a colleague",8,IF(B2="Requested website address for further details",9,IF(B2="Previously registered",10,IF(B2="Registered on the telephone now",11,IF(B2="Change of personal or company details",12,IF(B2="Do not call back, they will let us know",13,IF(B2="Other, note details",14,"Select outcome please"))))))))))))))
What it does is if it sees that a cell contains one of the conditions (such as the text "No answer, call back", it will become the relevent number), but on 2003 I can only get it working for 7 out of the 14 codes I want!
If someone could tell me how I could achieve the same thing on 2003 you'd be doing me a massive favour, I'm told the nesting problem can be overcome using VBA, but I don't really know how to do it.
If this is a bad forum to post for this kind of advice, pointing me in the right direction would also be appreciated.