+ Reply to Thread
Results 1 to 3 of 3

Formula for budget variance

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    London,England
    MS-Off Ver
    Excel 2002
    Posts
    54

    Question Formula for budget variance

    Dear members,

    Can anyone please help me in finding a way to compare the two budgets i.e 08/09 and 09/10 and if a new cost centre appears in 09/10 it will bring a yes in column G(New cc) and if the Cost Centre already exist in 08/09 it will bring a blank--but in both cases i want a variance in the next column H i.e 09/10 less 08/09.

    If anyone can help me on this i will be very grateful.


    many thanks
    Attached Files Attached Files
    Last edited by ordinateur; 05-18-2009 at 06:35 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Formula for budget variance

    I would go for:

    G3: =REPT("YES",ISNA(MATCH(E3,$B$3:$B$14,0)))
    H3: =F3-IF(G3="YES",0,VLOOKUP(E3,$B$3:$C$14,2,0))

    copy down & alter ranges as required

  3. #3
    Registered User
    Join Date
    02-11-2009
    Location
    London,England
    MS-Off Ver
    Excel 2002
    Posts
    54

    Re: Formula for budget variance

    Hi DonkeyOte

    I was hoping you were on the forum as you did help me with a complex formula before and you helped me again this time, i am really grateful.

    The formula works perfectly.


    Many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1