Recent content by reeljustice

OK guys, John first (failed) then Zatharas (success but don't know why). John first: I've tried doing the array deal with the "Ctrl+Shift+Enter" as follows: Cells F:5 thru F:8 100000 500000 10000000 100000000 Cells G:5 thru G:8 $2.00 $1.50 $1.00 leaving the remainging cells blank Used the...

Glenn: I was able to use your example above, but, I have an added issue --- my quantity has to be divided by 1,000 then multiplied by the progressive pricing. Would you please see if you can help me on this thread? http://www.tek-tips.com/viewthread.cfm?qid=1288683&page=1 Thanks, Joel

John: I attempted to apply the reasoning (not very well) to my situation, but, couldn't get it to work. Zathras, I think your reasoning is somewhat along the same lines but I don't know how to "assign a range name". I also looked at this article http://cpearson.com/excel/pricing.htm attempting...

Many thanks Bob. I'll give that a shot. Also, John recommended this thread: http://tek-tips.com/viewthread.cfm?qid=1282681&page=1 Sincerely, Joel

Many thanks John. I'll give that a shot.

Not sure this is in the correct forum, but here goes. Here is my quandry. I need calculations performed for different states. Each state has a different computation to arrive at the $$ charged. For example: NC fee computation We have a total dollar amount, say $800,000.00 The fee is computed...

Not sure this is in the correct forum, but here goes. Here is my quandry. I need calculations performed for different states. Each state has a different computation to arrive at the $$ charged. For example: NC fee computation We have a total dollar amount, say $800,000.00 The fee is computed...

That was it exactly. Thanks so much. Now if I can just figure out my formula from several years ago and adapt it to my current situtaion. Many thanks, Joel

I haven't used Access in a couple of years. I created a DB some years ago where I did not want the users to be able to view/change the forms, queries, etc. I only wanted them to be able to view the "finished" product and do the data input. I remember there was an "alt+key" combination I hit...