Nested IF / AND Calculated Fields

I've reviewed the "Calculated Fields Reference Guide" and done some searching on the topic to no avail. I am trying to create a read-only field with a calculated value based on a calculated entry in another field. Like this:

Field3 provides the sum of Field1 - Field2

So if Field1 has an entry of "100" and Field2 has an entry of "25" Field3 will calculate 100 - 25 = 75. Simple math. No problem.

I now want to use that result to calculate another field. Like this:

{{newInfo_es_:calc(if(Field3<100,5,15))}}

That also works, no problem. Since in the above example Field3 = 75 the result in newInfo is "5".

The problem occurs when I try to calculate based on the following logic:

IF Field3 = 0 THEN newInfo = 0

IF Field3 > 0 AND < 100 THEN newInfo = 5

IF Field3 > 99 AND < 150 THEN newInfo = 10

ELSE newInfo = 15

Here is how I wrote the calculation, which Adobe Sign does not like:

{{!newInfo_es_:calc(=if(Field3=0,0,if(and(Field3>0,Field3<100),5,if(and(Field3>99,Field3<150),10,15)))}}

This was actually TOO much for the area in the document where I wanted it, so I also used reference tags like this:

{{$NEW}}

{{#NEW=!newInfo_es_:calc(=if(Field3=0,0,if(and(Field3>0,Field3<100),5,if(and(Field3>99,Field3<150),10,15)))}}

The result was when uploading into my Adobe Sign library, and then opening it, it called this whole thing out as an error. I am going to go back in, and remove the reference to see if that is part of the problem, to see if the calculation works -- but since I couldn't find any instructions regarding nesting IF and AND statements, I am guessing that is the issue.

Any helpful feedback from someone who has accomplished this would be very much appreciated.

Thanks!

DAVID