| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VBA Functions Excel 2002
Please help.
I have created a Function (see below) but regardles of the numbers I enter, I can only get one result to display. That result is Poor-Improving Grrrr! What am I missing here? can anyone help-Please!!! Function EvalAll(OverallEval As Double) If RecentEvaluation = OverallEvaluation And OverallEvaluation 4 Then EvalAll = "Good-Improving" ElseIf RecentEvaluation = OverallEvaluation And OverallEvaluation < 4 Then EvalAll = "Poor-Improving" ElseIf RecentEvaluation = OverallEvaluation And OverallEvaluation 4 Then EvalAll = "Good-Improving" ElseIf RecentEvaluation = OverallEvaluation And OverallEvaluation 4 Then EvalAll = "Poor-Interview" End If End Function I have looked at this for so long without success and now I am not sure what I am doing anymore!!! Cheers Sherry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 versus 2002 seem incompatible related to the EDATE fun. | Excel Worksheet Functions | |||
| Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2002 help | Excel Worksheet Functions | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
| Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
Threaded Mode
