These 7 fields each have a numeric value of either positive, negative, or 0 value. Right now, I have a calculation that adds all of these fields, but I only want it to add the values that are greater than 0. I am not sure of how to write the "If"

current formula

Eng Needed + Math Needed + Science Needed + Soc Sci Needed + FaFl Needed + P E Needed + I S Elect Needed

not sure if this is correct or how to finish

If (Eng Needed > 0 & Math Needed > 0 & Science Needed > 0 & Soc Sci Needed > 0 & FaFl Needed > 0 & P E Needed > 0 & I S Elect Needed > 0; add

You could do an If statement for each test (you do not need to put them on separate lines as I have done for presentation):

If ( Eng Needed > 0 ; Eng Needed ; 0 ) +

If ( Math Needed > 0 ; Math Needed ; 0 ) +

If ( Soc Sci Needed > 0 ; Soc Sci Needed ; 0 ) +

...

Or you could use Max, which would be shorter and easier to read:

Max ( Eng Needed ; 0 ) +

Max ( Math Needed ; 0 ) +

Max ( Soc Sci Needed ; 0 ) +

...