Need help why this formula isn't working correctly!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • April H
    New Member
    • Nov 2010
    • 1

    Need help why this formula isn't working correctly!

    =if(Function Desc(Buying)=$9 5,if(Function Desc(Planning)= $115))
  • dsatino
    Contributor
    • May 2010
    • 393

    #2
    Many reasons.
    It seems your understanding of the function itself is flawed and your syntax is a wreck. All of this is easily correctible, but you haven't supplied enough info for anyone to help you.

    Where are you trying to put this function?
    Is 'Function Desc' another function or a field name of some sort?
    What is it you're trying to do?

    My guess is that you're trying to get the function to return either $95 or $115 depending on whether some other parameter is either 'buying' or 'planning'. But that's a guess because even if your syntax was good, your function isn't actually set up to return any results.

    If you're new to Access, and aren't sure how to explain it then just do the best you can.

    Comment

    Working...