Results 1 to 3 of 3

Thread: Formula Help

  1. #1
    Seeker Dnyan's Avatar
    Join Date
    Aug 2011
    Location
    Mumbai
    Posts
    13
    Articles
    0

    Question Formula Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have some query about formula, I tried by unable to found correct answer.


    The error is coming if outstanding amount is given then count showing in paid and outstanding coloumn.

    You can check below conditions and put the date in data sheet then you will know the error.

    If paid claim given then count will be only paid = correct

    if paid claim & outstandng cliam given then count will be only Outstanding claim. = ?

    if only outstanding claim given then count will be only outstanding claim = wrong

    if zero amount given in paid then count will be paid claim count and if zero amount given in outstanding claim then count will be outstanding claim only.= ?

    please check Data sheet and Summery sheet in attach file.

    Regards
    Dnyan
    Attached Files Attached Files

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    Im sorry but you'll have to explain yourself better, i've read your post and looked at your example and still cannot make sense of what you want.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  3. #3
    Seeker Dnyan's Avatar
    Join Date
    Aug 2011
    Location
    Mumbai
    Posts
    13
    Articles
    0

    Formula Help

    Hi,

    Thank for reply but now I got the formula for this.

    actually ther query was

    Hi,

    I am daily updating claims as per Renewal Date. It means every time renewal date will be change.
    For example.
    If Renewal date is 10/03/2011 then we add the claims as per renewal date like: 10/03/2011 to 09/03/2012.
    If the Renewal date is change to 05/04/2011 then we add the claims as per renewal date like: 05/04/2011 to 04/04/2012.

    So, want to sort date in another sheet as per Renewal Date for yearly period.

    But now ther problem is resolved.

    Thanks & Regards
    Dnyan



Posting Permissions

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