A1 is a number between 1-10
A2 is either 0 or 1.
I defined A3 as a formula: MAX(A1,1000*A2)
So if A2 is 1, then it will be 1000. Otherwise it will take A1.
It didn’t work. I changed it to
IF(A2=1,1000,A1)
And now it works.
Hi,
The MAX() formula cannot be used by referencing another formula directly. You would need to create another field (A3), which has the formula 1000A2. And then your MAX() formula should be set as MAX(A1,A3), and field A3 will have the value of 1000A2.