Add greater then in formula

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
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.
Photo of Gene

Gene

  • 94 Points 75 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,322 Points 20k badge 2x thumb
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,
(Edited)
Photo of Gene

Gene

  • 94 Points 75 badge 2x thumb
Yes, that works. But after applying, I actually need that replaced with [Date] >30 days from today.
[Date] is a date field