Is there a maximum number of nested if statements?
I have ended up with a long string of nested ifs and it is giving me an error in one, however as I can't see the error I am wondering if there is a maximum length?
As an alternative.
I have 4 tables of comparitive values in seperate sheets. Say Cell B9 in sheets 1-4.
Is there a command where I can get excel to give me the largest value, or a test string indicating the largest value?
Thanks
I have ended up with a long string of nested ifs and it is giving me an error in one, however as I can't see the error I am wondering if there is a maximum length?
As an alternative.
I have 4 tables of comparitive values in seperate sheets. Say Cell B9 in sheets 1-4.
Is there a command where I can get excel to give me the largest value, or a test string indicating the largest value?
Thanks