+ Reply to Thread
Results 1 to 2 of 2

Excel / Access Formula

  1. #1
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Excel / Access Formula

    Hello all,

    This is actually an access Formula, but im pretty sure someone with excel formula knowledge may know what this means:

    What does the "<>" mean, please help! Further, can you please distinguish what the difference of these two forumals are telling me?

    Example 1
    Sum(IIf([cash_dp]<300 And [mkt_typ]<>'L' And [has_voa_payment]=0 And [status] & [det]<>'XBT' And [contr_orig]<>'E' And (([Line]='Inhouse' And [contr_orig]<>'N') Or ([Line]='Dayline' And [contr_orig]='N')),[sales_volume],0))

    Example 2
    Sum(IIf([cash_dp]<300 And [mkt_typ]<>'L' And [has_voa_payment]=0 And [status] & [det]<>'XBT' And [contr_orig]<>'E' And (([Line]='Inhouse' And [contr_orig]<>'N') Or ([Line]='Dayline' And [contr_orig]='N')),1,0))

    Thank you very much!

    Hendrix P.
    Last edited by henrock24; 04-17-2015 at 03:59 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,471

    Re: Excel / Access Formula

    does not equal

    you need to change your title - see rules http://www.excelforum.com/forum-rule...rum-rules.html

    1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Opening Excel from Access, running Code in Excel then export back to Access
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2012, 08:49 AM
  2. Using Excel formula in Access
    By PavHolborn in forum Access Tables & Databases
    Replies: 2
    Last Post: 02-21-2012, 02:53 PM
  3. Excel Formula equivalent of Access Formula
    By adam90 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-13-2010, 07:37 AM
  4. Excel to Access - formula does not work...
    By f_disk in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-19-2006, 07:15 AM
  5. [SOLVED] Excel Formula or access ?
    By taxmom in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-16-2006, 01:25 PM

Tags for this Thread

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