Hey all!
I created 3 basic formulas (Field 1 / Field 2) however, we want to change that logic a bit to be IF statement - to which I need help
- Formula (percentage) would be something like this:
- Field A is greater than 0 THEN Field A / Field B
- If not, 0%
Any help is greatly appreciated
3 respuestas
You'd write it like this
IF(
AND(
Field_A > 0,
Field_B > 0
),
(Field_A / Field_B),
0 )
