| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Cells
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Cells
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 "stkrka" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Cells
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 "joemeshuggah" wrote: 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 "stkrka" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Cells
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? "stkrka" wrote: 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 "joemeshuggah" wrote: 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 "stkrka" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Cells
That should work. Thank You.
"joemeshuggah" wrote: 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? "stkrka" wrote: 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 "joemeshuggah" wrote: 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 "stkrka" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding the value of cells than 4.5 | New Users to Excel | |||
| Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
| adding cells | Excel Discussion (Misc queries) | |||
| adding cells | Excel Worksheet Functions | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Linear Mode
