How to Identify If an Array have blank or -ve values

[mandukes]

Please see the code below :

Please Login or Register  to view this content.

I have a situation where later in the code I have to check if the negVal Array has Blank or -ve values
If negVal has -ve value(s) then find the max negative value, If it has only one -ve val then return that value
If nevVal has no negative Val or 0 blank then only go check posVal Array and find max +Val

Regards

[TMS]

Why not a) count the positive and negative numbers as you store them and b) store and track the greatest positive number and the greatest negative number as you go along?

You've already checked if the number is negative or positive so add counters and storage variables.

Regards, TMS

[kalak]

I don't clearly see your problem.

Your code seems to define elements of nagVal (earlier declared as negVal) as negative values of A.

Are you wanting to check if negVal(?) has any negative elements instead of being entirely empty?

If so, does your "Max" of a negative number mean closer to zero or further from zero (i.e. max in the negative direction)? And, if such value exists, what do you want done with it?

[mandukes]

I don't clearly see your problem.

Your code seems to define elements of nagVal (earlier declared as negVal) as negative values of A.

Are you wanting to check if negVal(?) has any negative elements instead of being entirely empty?

If so, does your "Max" of a negative number mean closer to zero or further from zero (i.e. max in the negative direction)? And, if such value exists, what do you want done with it?

1. Your code seems to define elements of nagVal (earlier declared as negVal) as negative values of A
Ans. It was a typing mistake .
2. Are you wanting to check if negVal(?) has negative elements
Ans. YES
3.If so, does your "Max" of a negative number mean closer to zero or further from zero (i.e. max in the negative direction)?
Ans. further from zero
Getting max value is not a big deal.I can get it through
MaxNeg = Excel.workbookfunction.Min(negVal)

[mandukes]

Why not a) count the positive and negative numbers as you store them and b) store and track the greatest positive number and the greatest negative number as you go along?

You've already checked if the number is negative or positive so add counters and storage variables.

Regards, TMS

It's a good suggestion but I don't want to do it that way!

[TMS]

Fair enough.

Regards, TMS

[kalak]

1. Your code seems to define elements of nagVal (earlier declared as negVal) as negative values of A
Ans. It was a typing mistake .
2. Are you wanting to check if negVal(?) has negative elements
Ans. YES
3.If so, does your "Max" of a negative number mean closer to zero or further from zero (i.e. max in the negative direction)?
Ans. further from zero
Getting max value is not a big deal.I can get it through
MaxNeg = Excel.workbookfunction.Min(negVal)

Here's a modification of your code. You can look at this (run it on a blank worksheet, it generates its own test data) and see if you find anything useful from it.

Please Login or Register  to view this content.