+ Reply to Thread
Results 1 to 2 of 2

Adding a condition with present formula

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Adding a condition with present formula

    Dear Experts,

    Please find here attached worksheet, In cell K7 i have added one formula which is providing the results based on starting date and getting end till the completion of end date for every month based on the conditions in row 1 for months, but now i would like to add one more condition in row 2 for categories. If i would select a category in cell B7 then the amount should appear only for that category starting with the starting date and should end at end date only for that particular category. Request to you Experts, Please help me out.

    Seeking for your precious help and valuable support. Thank you for your treasurable phase and kind support.

    Regards,


    Neilesh
    Attached Files Attached Files
    Last edited by Neilesh Kumar; 11-09-2016 at 07:36 AM. Reason: By mistaken added an attachment with wrong formula

  2. #2
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Adding a condition with present formula

    Dear Experts,

    Request to you kindly ignore the first attachment, as added with wrong formula, i have corrected the formula in the second attachment. Request to you please see the second attachment.

    Regards,

    Neilesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding a second condition to an existing formula
    By ZedaG in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2016, 07:26 PM
  2. [SOLVED] I want to copy down formula present in a row till it meets a certain condition. (VBA)
    By balajidream in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-05-2016, 11:13 AM
  3. [SOLVED] Adding a new Condition to a current Formula
    By hammer2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-17-2015, 04:36 PM
  4. [SOLVED] formula to tell me when someone is present on work, present late and early departure.
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 01:38 AM
  5. Need help adding another condition to IF formula
    By gibson2503 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2013, 10:03 AM
  6. Adding an IF condition into an existing formula.
    By dmejia174 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2013, 07:33 PM
  7. Adding condition to existing formula
    By KINNEY0201 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-16-2010, 01:42 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