f********s 发帖数: 658 | 1 This is a function I created to calculate sales people performance. It works
fine but there is a minor problem. I defined the function as variant
because the result could be both empty or a number. The first "if" sentence
I want to have a empty result in the Excel cell. Other "if" sentence result
in "0" or "numbers". However, when I use this function I found it can only
show "0" in the first "if" sentence instead of showing nothing. I tried to
figure it out but don't know how to do this.
I am a |
a******e 发帖数: 132 | 2 If rampmon <= 0 Then prodty = blank |
f********s 发帖数: 658 | 3 Thanks. Are you serious?
【在 a******e 的大作中提到】 : If rampmon <= 0 Then prodty = blank
|
a******e 发帖数: 132 | 4 ...
blank means blank cell in Excel VBA
i am serious ... |
f********s 发帖数: 658 | 5 I tried but it doesn't work.
【在 a******e 的大作中提到】 : ... : blank means blank cell in Excel VBA : i am serious ...
|
s*********i 发帖数: 66 | 6 Change second If statement to "If 0 < rampmon And rampmon <= 1". |
f********s 发帖数: 658 | 7 Thank you Starbuckswi!
I revised my program as you said. Now it works! I really appreciate your
help.
【在 s*********i 的大作中提到】 : Change second If statement to "If 0 < rampmon And rampmon <= 1".
|