IIf syntax problem

What is wrong with...

=IIf([txtATDemand]-[txtATwipANDfgQty])<0,0,([txtATDemand]-[txtATwipANDfgQty])

--Steve
SteveL13Asked:
Who is Participating?
 
CluskittCommented:
Actually, =IIf([txtATDemand]-[txtATwipANDfgQty]<0,0,[txtATDemand]-[txtATwipANDfgQty])
0
 
CluskittCommented:
Number of parenthesis:
=IIf([txtATDemand]-[txtATwipANDfgQty])<0,0,([txtATDemand]-[txtATwipANDfgQty]))
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.