Case statement not working

I wrote this short program that parses out last name and zip code from one cell into two cells so I can map the sales data. I flagged each sale as either member, non-member, or neither, based on the prices of the items (members get 25% off). I used the case statement below.

the problem is that for one of the sale items it's getting flagged as "neither" despite being at the members price level. it works for that same item in other records. the quantity at error point is 3 for two of the errors and 6 for the third, but the strange thing is it works for a few other sale records in which the person also bought 3 of that item (the quantity is not the culprit, or sole culprit).

Here's the code. Obviously Price and Quant are the two variables involved. I declared Price as a double and Quant as an integer, even though both have two decimal places in the data file. That way the product of Quant and each items price for one and Price will both have only two decimal places even though it was rounding off that product to two decimal points without declaring either variable. I cut out some of the case statement so as not to exceed the character limit.

Please Login or Register  to view this content.

If the entire program is required, with or without a data file, I can post that later. I was hoping someone would have had a similar problem and recognize an answer without viewing the whole kit and kaboodle.

Thanks, gary

Thanks Leith and Donkeyote. I actually had it ordered in ascending order within groups - the maps came first, then the books, then the combo items (book and map), then novelty items. I had to cut over half out because I exceeded the character limit for a post.

I was aware of the double listing problem and had caught an error in which the correct case didn't execute because it had gone into a preceding case, but had corrected it for that one, but obviously not all of the duplicate prices. I will fix that, and also try the Round function.

I hope it works because posting the whole program will also exceed the character limit, and my guess is a file attachment has a limit too small for the whole excel file, code and all. I could always have a data file of just 10 or so records (instead of the thousands it has) that included the ones the program fails on.

Gary

You were right - the Round function worked. I don't understand why because the program was giving wrong results on only some of the quantities. All the quantities had two decimal places (both zero) and all the prices had two decimal places so without the Round it should have failed on all the records, but it did so only for three as far as the East Hudson trail map item goes. Two were quantity three and one quantity six. it worked for the other ones with quantity three.

I'll just toss this up to a gremlin in the code - sometimes the values must have been stored with more decimal places, sometimes with fewer, and with the Round the ones with more were simply truncated to two places so it worked.

In any event, thanks again,

Gary