Closed Thread
Results 1 to 2 of 2

Find the difference in a cell value and add a formula based on that only on next three row

  1. #1
    Registered User
    Join Date
    08-24-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    7

    Find the difference in a cell value and add a formula based on that only on next three row

    Hi Friends

    I am trying to calculate the cost of some employees. by month.

    lets assume the beginning of the year I had 4 employees and then I added one during Apr. So I need to consider recruitment cost during Apr, May, Jun. Lets say my average is 50% on the salary, I would split that between Apr, May and Jun. So the formula should find the cell with a new recruit and then add the % increase in that cell, and next couple of cells by row. Attaching an example for ease of understanding.

    Cheers
    Sreeram
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Find the difference in a cell value and add a formula based on that only on next three

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to find the difference betwwen two rows based on conditions
    By Thinker8 in forum Excel General
    Replies: 11
    Last Post: 11-08-2013, 04:32 AM
  2. How do find the difference between 2 times based on a third column
    By jtpryan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2013, 11:18 PM
  3. [SOLVED] Formula to find out MAX and MIN based on 3rd cell condition
    By helpbitte in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2013, 05:31 AM
  4. [SOLVED] Formula to find the working days difference between to dates?
    By Mudgeman in forum Excel General
    Replies: 2
    Last Post: 05-15-2006, 02:35 AM
  5. how do i put formula to find difference between two dates
    By A.D in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-12-2005, 01:06 PM

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