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 risposte
Eric Praud (Activ8 Solar Energies) Forum Ambassador
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