Thread: YTD budget based on current input of actual
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sanj Sanj is offline
external usenet poster
  
Posts: 25
Default YTD budget based on current input of actual
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD
actual 10 20 30 40 30 130
budget 15 15 20 25 20 25 35 20 25 30 35 15 .......

Need a formula in YTD budget row so that when I enter 10 in Jun actual (140
YTD actual) so that I can get 120 in YTD budget. Thanks for the help.
Sanj

Reply With QuoteReply With Quote