LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default formula for budget

Good day
this is the excel worksheet before me

item Budget Curr Budget Jan Feb Mar
comp h/w 5000 **** 1000 500 200
hort 6000 ****
animal prod 2000 ****

What formula should I use to workout the current budget. So initially I have
R5000 then I purchase comp h/w for R1000 in jan the current budget should be
R4000 and then purchase comp h/w in feb the current budget should be 3500 and
then purchase in mar the curr budget must be 3300. How can u accomplish this?

Thanking you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula statement that would spread an annual budget over 12months [email protected] New Users to Excel 1 March 23rd 08 12:07 PM
Formula for Budget Sarah Excel Discussion (Misc queries) 5 December 31st 07 07:19 PM
Excel formula to calculate % difference when actual 1, budget -48 yuppy flyer Excel Discussion (Misc queries) 1 March 23rd 07 12:34 PM
Formula to return under-budget store locations BeckyRode Excel Worksheet Functions 6 July 6th 06 07:27 AM
Divide Monthly Sales Budget to Day Budget Benedikt Fridbjornsson Excel Worksheet Functions 2 January 10th 06 03:42 PM


All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"