Number of If statements on a worksheet?
Number of If statements on a worksheet?
(OP)
Is there a limit to the number of cells on a worksheet that can have if statements?
I kow you can nest 7. I want ot put 200+ on one sheet and somewhere around 60 it seems to ignore them.
I have searched help and as usual if I don't ask exactly the right question I don't find it.
sorry of such a stupid question, I'll keep trying. I do appreciate the help I know I'll get here. Thank you.
BJC
I kow you can nest 7. I want ot put 200+ on one sheet and somewhere around 60 it seems to ignore them.
I have searched help and as usual if I don't ask exactly the right question I don't find it.
sorry of such a stupid question, I'll keep trying. I do appreciate the help I know I'll get here. Thank you.
BJC





RE: Number of If statements on a worksheet?
RE: Number of If statements on a worksheet?
Thank you.
I'll keep trying. I am doing something that I am knot seeing. Brute force and persistence will prevail.
RE: Number of If statements on a worksheet?
RE: Number of If statements on a worksheet?
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.