Thread: How do i keep the total of 3 variables constant
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
southwestpaddler
 
Posts: n/a
Default How do i keep the total of 3 variables constant
I want to input 3 variables into my spreadsheet, each needs to be able to be
altered but the total must never be more than 100. Can the other cells be
automatically altered to achieve this?

Reply With QuoteReply With Quote