Thread
:
formula for budget
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
formula for budget
With the Comp h/w expenditures in E2:P2, try:
=B2-SUM(D2:P2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"excel determine no failed."
m wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann