Formula to avoid a negative number

Hello,

I am looking to update the following formula I use.

The last part of the formula will check E3, if the text "No" is present, the result would be -0, if anything else is present, the result would be -1.

What I am looking to do is not have the result going into the negative.

For example, if the first part of the formula returns a .5, the result would be -.5

If the result is a negative number, I would like it to display a 0.

Is that possible?

=IFERROR(IF(OR(A3="",B3="",C3="",D3="",E3=""),"",IF(D3="No",1,IF(D3="Yes",2,0))*VLOOKUP(C3,'List Data'!$I$1:$J$18,2,FALSE)-IF(E3="No",0,1)),"0")

I appreciate any help.

Thanks,
Nick

How about

Formula:

Please Login or Register  to view this content.

That's perfect Fluff! Thank you.

You're welcome & thanks for the feedback.