=if(Function Desc(Buying)=$9 5,if(Function Desc(Planning)= $115))
Need help why this formula isn't working correctly!
Collapse
X
-
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