Results 1 to 5 of 5

a more concise formula

Threaded View

jwongsf a more concise formula 01-14-2009, 10:35 PM
JBeaucaire DCOUNT might help, look into... 01-14-2009, 11:39 PM
Domenic Try... ... 01-15-2009, 12:33 AM
jwongsf Thank you thank you, it works... 01-15-2009, 02:23 AM
jwongsf solved 01-15-2009, 10:20 AM
  1. #1
    Registered User
    Join Date
    07-16-2007
    Location
    San Francisco, CA
    MS-Off Ver
    2010
    Posts
    93

    a more concise formula

    Can anyone help to make this formula more concise and shorter, it was design to check a numbers in a range to see if any of them falls into a particular range.

    =IF(SUM((COUNTIF(Fund,">11999")-(COUNTIF(Fund,">12999"))),(COUNTIF(Fund,">21099")-(COUNTIF(Fund,">28729"))),(COUNTIF(Fund,">28730")-(COUNTIF(Fund,">33999"))),(COUNTIF(Fund,">58999")-(COUNTIF(Fund,">59999"))),(COUNTIF(Fund,">82000")-(COUNTIF(Fund,">84999"))),(COUNTIF(FUND1,">11999")-(COUNTIF(FUND1,">12999"))),(COUNTIF(FUND1,">21099")-(COUNTIF(FUND1,">28729"))),(COUNTIF(FUND1,">28730")-(COUNTIF(FUND1,">33999"))),(COUNTIF(FUND1,">58999")-(COUNTIF(FUND1,">59999"))),(COUNTIF(FUND1,">82000")-(COUNTIF(FUND1,">84999"))))>0,"ATTACHMENT E IS REQUIRED","")

    and if the any of the number fall into the range it will print the message, "Attachment is Required"

    Thanks James
    Last edited by jwongsf; 01-15-2009 at 10:44 AM. Reason: solved

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