Skip to main content
Question

Add greater then in formula

  • November 29, 2017
  • 0 replies
  • 40 views

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.
This topic has been closed for replies.

  • Registered
  • November 29, 2017
Remove the extra comma before the second and:

If([Return Needed] and [Installation] = "Self-Install", and [Numberfield] <30,

If([Return Needed] and [Installation] = "Self-Install" and [Numberfield] <30,

  • Author
  • Registered
  • November 29, 2017
Yes, that works. But after applying, I actually need that replaced with [Date] >30 days from today.
[Date] is a date field