Need two cells to equal a certain number

[stkrka]

This is my situation: I need to be able to enter a number between 0 and 15 in one cell, and have the number that will make the sum of the two cells equal 15 appear in another cell. I want to be able to enter the number between 0 and 15 into either cell.

[shg]

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.