I am trying to create a formula that divides by 2 the amount of the field “Quantitat” only if in the “Tipus” field it says “sacas” and places it in the field “Tones”. Is it possible? I am using the following formula: “IF (Tipus =” sacas “,” Quantitat "/ 2) is it correct?
You’re very close – just need to remove the quotes around your reference to the Quantitat field. Also, your condition checking for the value “sacas” will be case-sensitive, so “sacas” does not equal “Sacas”, as you have it typed in your Tipus field options.
IF(Tipus = "Sacas", Quantitat / 2)
You may want to round the results so you don’t have a large string of decimal digits…