Create conditional settings in a word table.

Job ID: 36667686

Budget: ₹2,500 – ₹0 INR

I am a psychologist and regularly complete intelligence tests. I need a template so that when I put a score in a cell the rest of the row will auto-populate. I have attached a file of both my template and the conditions...
For example, when I put in a composite score (also known as the index score or the standard score), I need the correct %ile to fill the next cell and the next descriptor to fill the last cell in the row.
So, if I put 100 under the composite score, the %ile cell would automatically be 50 and the descriptor would say fell within the Average range.
Related categories: Data Processing Data Entry Excel Word