Divisor = 0

[harrySCOTT]

I have a formula that is used to determine where an employee falls in their pay range. The formula is as follows the (Employee Hourly Rate-Range Minimum)/(Range Maximum-Range Minimum). If the employee rate=range minimum (meaning the divisor=0) then I use the following statement: if Employee Hourly Rate=Range Minimum then 0 else (Employee Hourly Rate-Range Minimum)/(Range Maximum-Range Minimum). When I run the report, I still get the error message "Division by 0." How can I get around this?

Thanks!

 

[mbarron]

harrySCOTT,
employee rate=range minimum, using the formula you supplied, won't result in a 0 divisor unless the employee rate is equal to both the minimum and maximum range because range max and range min have to be equal to have a zero divisor

Try this:

if employee rate=range minimum then 0 else
if (Range Maximum-Range Minimum)<> 0 then
(Employee Hourly Rate-Range Minimum)/(Range Maximum-Range Minimum)
Mike
If you're not part of the solution, you're part of the precipitate.