Adding Cells

S

stkrka

I have two cells. I want to be able to enter a number in either cell and have
the other cell fill in with the number that makes the sum of the two cells
equal to 15.
 
J

joemeshuggah

assuming your cells are in columns a and b you could

in column a type =15-B1 and in column b type =15-A1 and paste for the
desired range
 
S

stkrka

If I enter the formula in the cells, how do i enter a number in them also.
Also, when I tried to do what you suggested, excel told me I used a circular
reference
 
J

joemeshuggah

the circular reference can be ignored; you would type over the formula in
either row a or b. once one of the cells is typed over, the other will show
the number needed to sum to 15. is that along the lines of what you were
looking to do?
 
S

stkrka

That should work. Thank You.


joemeshuggah said:
the circular reference can be ignored; you would type over the formula in
either row a or b. once one of the cells is typed over, the other will show
the number needed to sum to 15. is that along the lines of what you were
looking to do?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting for time 1
Numbers changing between sheets 13
Question about conditional formatting of zeros in Excel 0
Excel Conditional Formatting 1
Results into one cell 1
link two spreadsheets and copy cell ref accross row 2
Finding Text within an Array 2
Conditional formatting based on the sum of two cells (Excel 2007) 1

Top