Results 1 to 2 of 2

Cell formula result unexpected when blank date criteria entered

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    17

    Cell formula result unexpected when blank date criteria entered

    Hello,

    I am hoping someone can help me. Attached is a spreadsheet which I'm hoping will calculate a dollar amount given a certain date criteria. The range of cells I am referring to are located in the spreadsheet:

    Worksheet: "variables"
    Cells: "O13:Z13"

    The formula I am using gives me an answer only when both a start date and end date are entered in L13 and M13 respectively. I would like the formula to work when the end date is either blank or not.

    I'm new to the forum and not sure if you have enough information.

    Be grateful for any help offered.
    Attached Files Attached Files
    Last edited by TGP; 07-06-2010 at 07:55 AM.

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