Skip to main content
Hi, 

 

 I have been trying to figure out a formula which gives set values based on the below logic, can someone help? 

 

A- 600 B-900

 

Imagining the above are fields I want to generate the value 'SG' if the A is smaller than B and I want to generate the value 'LG' if B is larger than A.

 

For reference, this formula will be used to generate a value inside a flow. 

 

Thanks, 

 

Shay

 

 
3 个回答
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2021年2月17日 15:24
    Hi Shay,

     

    You could simply do something like this:

    IF(AND(ISBLANK(A), ISBLANK(B), NULL,

    IF(A>B, "SG", IF(A<B, "LG", NULL)))

     

    I've added a NULL value if A=B, but you could also use the greater than or equal >= or Less than or equal <= symbols instead. For example:

    IF(AND(ISBLANK(A), ISBLANK(B), NULL,

    IF(A>=B, "SG", "LG"))

    Since LG can only show if A<B