Thank you for the response!
I still seem to be having some trouble (shocking!)...
1) I was using a content control dropdown, so I have switched that to the form field. The data in cell B3 can vary and I need to be able to change the input. Is there a way to allow that cell to be edited after protection is enforced?
2) After the formula, dropbox, and cell B3 are all correct. What is the best way to re-run the formula when one or more of the inputs get changed? Is this supposed to be automatic?
3) Finally, I am not sure if I have something incorrect with my formula. It spit out a number the first time, but when I tried to run it again I got a syntax error. I have attached a shot of the formula.
I would really appreciate any more assistance you could provide. Thank you so much for your help!
|