Hi all,
I am trying to do what I would think would be a pretty simple calculation. I have 3 numbers that I need to get a percentage from. Basically, I have a (x+y)/z=the desired precentage. ex: (1+2)/9*100 to equal 33.33%
Yet, there are many records that have zero's in the number, and I get a "Division by zero" error. I assume I need to write an IF statement to ignore any that have zeros in the record.
Any help would be great!