| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If-Then-Else resulting in DIV/0 error
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 -- scape ----------------------------------------------------------------------- scapen's Profile: http://www.excelforum.com/member.php...fo&userid=1515 View this thread: http://www.excelforum.com/showthread.php?threadid=26789 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup resulting in #N/A | Excel Discussion (Misc queries) | |||
| Negative Values resulting in error | Excel Discussion (Misc queries) | |||
| WORKDAY resulting in #VALUE error | Excel Worksheet Functions | |||
| Calculations resulting in #DIV/0! | Excel Worksheet Functions | |||
| Dll error resulting from "CreateWorkspace" | Excel Programming | |||
Threaded Mode
