if(a<0,0,if(ab,c,d)) should do it

Marion



"jmac2006" wrote:

Hi there,

I have a simple "if" statement and am trying to add a constraint.
Essentially, the statement is:

If(AB, C, D)

However, I wan to say if "A" is a negative number, then it should be 0
(can't have a negative number).

Anyone have any advice?

Thanks