Formula Assistance Needed

[JeffJones]

I have a parse error with the following formula.  Any idea what I am doing incorrectly?

Any assistance is much appreciated.

[bbak91 · Accepted solution]

Your error is because you don't have an actual condition in the elseif part of the statement. Your statement reads:

If total acw3 = 0 then set the value to zero. Otherwise, round total acw3 to the nearest multiple of 1. For everything else, keep total acw3 value as is. You can see how the second part of the condition doesn't really make sense because you are treating it the same way you would handle the else condition. Without an actual criteria it is evaluating to it doesn't make sense. 

It sounds like maybe your ELSE part of the statement is redundant. Maybe try:

IF [Total ACW3] = 0

THEN 0

ELSE Round([Total ACW3], 1)

ENDIF

[JeffJones]

Thank you so much for your assistance