Results 1 to 6 of 6

How to stop cells displaying results outside required parameters

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2010
    Location
    North West
    MS-Off Ver
    Excel 2003
    Posts
    9

    How to stop cells displaying results outside required parameters

    Hi,

    I need to find a formula that can stop a value being returned once certain peramiters are exceeded.

    For eaxmple, a policy is valid for 7 days.
    The start date is January 4th, and expiration is Kanuary 10th.

    I need to display the number of days used, and the pro rata cost of the policy used.

    The problem is regarding policies which start before the required start date resulting in an overstatement in policy value, and days used. (highlighted in red).

    Ideally, I need to somehow fix the values returned in the red cells to the total cost of the policy. ie, it has been used, therefore 7 days cost applied, and not eight, and £70 displayed instead of £80.

    I hope my explination is clear enough. I have attached a sample data.

    Thanks all in advance

    Sai
    Attached Files Attached Files
    Last edited by Sai Sari; 08-02-2010 at 04:58 PM.

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