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.

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 1000*A2. And then your MAX() formula should be set as MAX(A1,A3), and field A3 will have the value of 1000*A2.