Forum Discussion

RhondaJones's avatar
RhondaJones
Qrew Cadet
7 years ago

Coding fix to include second option

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.
Formulas and functions
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    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's avatar
    RhondaJones
    Qrew Cadet
    7 years ago
    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! :)