To see what can be done in Word, check out my
Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/word/...-tutorial.html
As your worksheet employs a dropdown, something similar could be done via a dropdown formfield or content control; the former requires the use of 'filling in forms' protection, whilst the latter would require a macro.
An alternative would be to embed such a worksheet in the document itself.