IF Statements Help - DESPARATELY NEED HELP!!

[willlobb]

Is there a limit on how many IF's you can have in an IF statement. after about seven, the formula doesnt work. if there is a limit, is there any other option? can i use something like the Case function? or can u run a macro from changing the contents of a cell?
Thanks, Will
This message was edited by willlobb on 2002-04-06 03:49

 

[dk]

http://www.mrexcel.com/board/viewtopic.php?topic=4201&forum=2&2

try this for your hyperlink / macro enquiry..... courtesy of Mark O\'Brien


_________________

Chris you cheeky bugger My name's Dan not Mark!

Regards,
Dan

 

[willlobb]

thanks a lot for all those replies, Chris/Mark, will the hyperlink/macro thing work if i have more than one hyperlink on the page?
Thanks again
Will

 

[Chris Davison]

Dan,

what the smeg ?!

I dunno what happened there mate, I do apologise profusely !

too many windows open combined with too many Grolsch's....

("Shhhhtop, this message, it is not ready yet...")

LOL