Hello folks,
I am trying to muddle my way through another JET report and need help subtracting FIELDA from FIELDB IF they are both > "0" filling FIELDC.
IF both FIELDA and FIELDB are NOT >"0" then FIELDC should be left blank/empty.
Hope this makes sense, can anyone help? Any pointers apprciated.
Regards,
K
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Is this what you are looking for, K?
Cell A5 FieldA
Cell B5 FieldB
Cell C5 =IF(AND(A5>0,B5>0),A5-B5,"")
Please sign in to leave a comment.