# MAX Function does not work properly

**URL:** <https://community.ragic.com/t/max-function-does-not-work-properly/5870>\
**Category:** Bugs\
**Created:** [September 5, 2020, 9:12pm UTC](https://community.ragic.com/t/max-function-does-not-work-properly/5870 "2020-09-05T21:12:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![healingaura](https://community.ragic.com/letter_avatar_proxy/v4/letter/h/76d3ee/32.png) [@healingaura](https://community.ragic.com/u/healingaura)\
**Post date:** [September 5, 2020, 9:12pm UTC](https://community.ragic.com/t/max-function-does-not-work-properly/5870/1 "2020-09-05T21:12:21Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![fabio](https://community.ragic.com/user_avatar/community.ragic.com/fabio/32/2909_2.png) [@fabio](https://community.ragic.com/u/fabio)\
**Post date:** [September 7, 2020, 8:39am UTC](https://community.ragic.com/t/max-function-does-not-work-properly/5870/2 "2020-09-07T08:39:13Z")

</div>

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.