If-Then-Else resulting in DIV/0 error

[scapen]

Help Please!!

I am doing a homework assignment that requires an IF statement to b
included in my macro. My problem is my Average Salary contains
daverage function....so when my Number of Employees equals zero
average salary results in DIV/0 error message. I'm not sure how t
write my If statement to display 0 in the average salary when th
number of employees equals 0. Any help would be appreciated.

Thank you

 

[duane]

right before you calculate the avg

if emp = 0 then avg = 0

continue with your code
where emp = # of employees and avg = average salar

 

[Tom Ogilvy]

You attached no file.