How can I see the formula used in this example

[debbys]

Good Evening

I have been using the attached document for years [I am not the author], I now want to create a completely different document but using the same idea of having a starting figure reduce/stay same etc depending on the response but I cannot work out how to see the formula used therefore cannot replicate.

Can someone help please?

TIA

Debby

[Pepe Le Mokko]

Perhaps in the formula bar ? (the result ss in merged cells, bad practice)

[debbys]

Thanks for the reply Pepe

I cannot see anything in the formula bar, I assume you are referring to C15/16 being merged, this is the example I am asking for help on, as I stated I am not the author.

D

[Glenn Kennedy]

If you're unfamiliar with the term formula bar.... Select the cell with the formula.... and there it is...

[63falcondude]

If you click on the merged cell (C15), you should see the formula =SUM(D3:D14) in the formula bar.

If you double-click on the merged cell (C15), you should see the formula, ready to be edited, in the cell.

[debbys]

Hi Glenn and thanks for the reply

I see and am familiar with the formula bar, what I am looking for is what has been used to generate the scores.

If you populate the individual cells C3 through C14 using the drop down menu the score in C 15 decreases when a response of no is entered, it is this function/formula that I am trying to see.

Untitled.jpg

Thanks

D

[63falcondude]

Are you talking about the numbers hidden in column D?

To see those, highlight columns C:E > Right-click > Unhide