Here is what I have. I'm not sure if I'm close and just overlooking something, or if I have completely wrong lol.
Please Login or Register to view this content.
Here is what I have. I'm not sure if I'm close and just overlooking something, or if I have completely wrong lol.
Please Login or Register to view this content.
Try this instead...
Formula:Please Login or Register to view this content.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you want to use those dollar amounts in further calculations, then you should remove the quotes symbols, as that will turn them into text values and not numeric values.
Hope this helps.
Pete
Pete, thanks (again) for that catch - did not even notice that part.
jwat1537 yup, pretty much. If you start with testing for greater than the largest, then testing for greater than the next-largest etc, you don't need to use both upper and lower limits.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks