I currently have the following formula:
If([Return Needed] and [Installation] = "Self-Install",
[Addon] + [New] + [Replace],
[Addon] + [New] - [Removal]
)
What I would like to add in the "If" statement, another "AND", with [Numberfield] <30
Kind of like this:
If([Return Needed] and [Installation] = "Self-Install", and [Numberfield] <30,
I tried different ways, and can't seem to get it.
[Numberfield] is a numeric formula, that displays end results in a number.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.