Help with if statement
-
Hello,
I’m trying to get an if statement added and am having trouble. I want it so that if the number is negative the output is 0. I have everything working but cannot get the if to work. Here is my code:
if((fieldname2 * (1.4/100) – (fieldname2 * (1.4/100) * fieldname13)) – fieldname2 * (1/100) < 0,0,(fieldname2 * (1.4/100) – (fieldname2 * (1.4/100) * fieldname13)) – fieldname2 * (1/100))
I will also want the decimal to the third point. I am not sure how that will work once the if statement is in (I have it working now using PREC but without the if statement).
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Help with if statement’ is closed to new replies.