I am trying to make a calculation on a number field ONLY if a checkbox is checked on field A16. Here is the formula for the number field:
So if the checkbox is activated, then the calculation should show. Otherwise the field is emptied.
Unfortunately, it seems that this formula will NOT work on a number field. I can get it working on a free text field, but I need the result to be formatted as a number, not as a text field that I can’t format.
Maybe explaining it this way is easier to understand and you can tell me why this doesn’t work and if there is a workaround:
Number field A1 = price without tax
Number field B1 = price with tax
Checkbox field C1 = price includes tax? Yes or X
If the user selects Yes in C1, then B1 automatically calculates A1 + the tax