Thread: Adding Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joemeshuggah joemeshuggah is offline
external usenet poster
 
Posts: 96
Default 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.