Coding fix to include second option

  • 38
  • 1
  • Question
  • Updated 2 weeks ago
  • Answered
I have a currency field with this code

If([Replace]=true, 0, [Amount Offered])

It works exactly as it needs to. "Replace" is a check box field. I need to amend the code to include a second check box field labeled "Repair". I need it to trigger if either one are checked They will never both be checked so it is an "or" statement rather than an "and" statement.

I'm also aware that this should be way easier than I'm making it but it's my busy season and my brain has stopped functioning. 

I would certainly appreciate the help.
Photo of Rhonda

Rhonda

  • 82 Points 75 badge 2x thumb

Posted 2 weeks ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,994 Points 20k badge 2x thumb
Your original formula might be just this:
If([Replace], 0, [Amount Offered])
And your amended formula might be just this:
If([Replace] or [Repair], 0, [Amount Offered])
It is a common mistake to write [checkbox] = true when [checkbox] alone will do the same thing.
Photo of Rhonda

Rhonda

  • 82 Points 75 badge 2x thumb
No it is exactly as I pasted it, I was simply giving the checkbox info to let someone know what type of fields they were in case it was relevant. 

Of course if would be as simple as putting or... Thank you so much for helping me get through the rest of this Friday! :)