Forum Discussion
Solved
multiply function IF OR AND
Hello, what should be the proper formula if you have to calculate (A-B)B, if there a options that A and B are zeros, or only B is zero. column = if(and('A=0,B=0), 0, (IF('B=0), 0, A/'B]) ...
Why dont you keep the formula as is (A-B)/B and if it gives you an error then convert the error to zero.
Simpler formula i think.
IFERROR( ([Sales]-[Target] / [Target]), 0)
