Sorry for the typo, the question should be:
If [a] = "1"is true
and [e] ="2" or [c] = "3" is true
then to sum up the d value of [e] and [c]
Also, I would like to create a 'if and' formula with three criteria but it has syntax error, please could someone point out the mistake. Many thanks.
Actual Test = iferror(if(and([project]="A", [Unit]="B",[Name]="C"),[Actual]/[Budget],[Actual])),0)