This worksheet has five different sections;
Each section has 3 option boxes, 1. Yes 2. No 3. N/A.
I have a value connected to each box-value and formula in hidden cells.
I attached the hidden cell by right clicking the box, and putting in the
cell reference.
So, this is how the formula reads: =if(ad17=1,2,if(ad17=2,0,if(ad17=3,2))).
This has worked fine,but it is the last section of the 3 options that is
giving me fits!
the last 2 sections of 3 boxes keep changing the reference cell everytime I
click on them. I have deleted and started over, used group boxes, prayed,
and nothing works, even though it has worked previously. I went through the
entire worksheet to see if anything else connected, sdid not find anything,
traced dependents. PLEASE HELP!! I'll be glad to send you the worksheet to
look at it. Thank you.