Use Condition in Cell editor

[Former Member]

Hello Guyz,

We are using cell restrictions and now there is a requirement where we need to introduce a condition,

Scenario:

In a Cell edition we have a formula consider A = B+C-D-E, 

If A < 0  the value of A = 0,

Please let me know can we create such a condition in Cells ??

Regards,

Ravi

[former_member223480]

Hi Ravi

In the cell formula, use the boolean functions and add the following

( B+C-D-E>0) * ( B+C-D-E)

Thank you

Yiannis