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".
|
