Skip to main content
Question

Coding fix to include second option

  • December 1, 2018
  • 0 replies
  • 57 views
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.
    This topic has been closed for replies.

    • anomDiebolt
    • Registered
    • December 1, 2018
    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.
    • RhondaJones
    • Author
    • Registered
    • December 1, 2018
    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! :)
    Terms & ConditionsAccessibility statement