A
artifex
Guest
I have a expression in a form field that is supposed to produce a percentage. (Bid - actual = diff) (diff/bid = percentage)
When all the fields are filled in and the difference is a positive number, everythings fine. However if the difference is a negative number or if there are zero values in all the fields, one of two errors are returned. Either #Div/0! or #Num!. Can any one help me start to trouble shoot? or define the error messages? Thanks!
When all the fields are filled in and the difference is a positive number, everythings fine. However if the difference is a negative number or if there are zero values in all the fields, one of two errors are returned. Either #Div/0! or #Num!. Can any one help me start to trouble shoot? or define the error messages? Thanks!