Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If-Then-Else resulting in DIV/0 error
Ok I'm confused...I know I don't have a really good handle o this.....here's what I have so far: If QualifiedEmployees = 0 Then AverageSalary = "0" MsgBox "There are no employees who meet all of the criteria. _ & "Please rerun the macro." Else MsgBox "Macros are made more powerful by adding " _ & "VBA statements." End If Thank -- scape ----------------------------------------------------------------------- scapen's Profile: http://www.excelforum.com/member.php...fo&userid=1515 View this thread: http://www.excelforum.com/showthread.php?threadid=26789 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If-Then-Else resulting in DIV/0 error
If there is a question hidden in your post, it is apparent.
-- Regards, Tom Ogilvy "scapen" wrote in message ... Ok I'm confused...I know I don't have a really good handle of this.....here's what I have so far: If QualifiedEmployees = 0 Then AverageSalary = "0" MsgBox "There are no employees who meet all of the criteria." _ & "Please rerun the macro." Else MsgBox "Macros are made more powerful by adding " _ & "VBA statements." End If Thanks -- scapen ------------------------------------------------------------------------ scapen's Profile: http://www.excelforum.com/member.php...o&userid=15156 View this thread: http://www.excelforum.com/showthread...hreadid=267893 |
Reply |
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 | |||
If-Then-Else resulting in DIV/0 error | Excel Programming | |||
Dll error resulting from "CreateWorkspace" | Excel Programming |