Change Formula When Checkbox Is Checked
I currently have the most simple formula: [Addon]+[New]-[Removal] What I would like, is: IF [Checkbox1] = checked, AND [Install] = Self, then output formula: [Addon]+[New]-[Removal]+[Replace] Bu...
Forum Discussion
Try this:
If([Checkbox1] and [Install] = "Self",
[Addon] + [New] - [Removal] + [Replace],
[Addon] + [New] - [Removal]
)
Looks perfect. Thank you!!