excel hell.

[nashvillesigns]

Price Sheets.
love what i created so far.
input size, get SqFt., get how much sheets of material you need, get a set price for size. get sale tax, get total.
problem?
all square foot pricing is related by size. there are at least seven different tiers here. the smaller ones cost way more per square than the mammoth signs.

for the life of me, i cannot get this #@$^!#%^@ program to adjust.
either by "lookup" or "tables."
does any body have a correct formula?
you can message my inbox your response if this question is uncomfortable to post.
i will change the cell keys to fit mine!
thanks
chris

 

[Christian @ 2CT Media]

Can you post your excel file so we can see what you are doing? your description is very vague from a programming stand point.

 

[J Hill Designs]

I'm guessing he needs some sort of if(sqft<x) {use(pricechartx)}

but i dont know excell programming, so not gonna chime in with help

 

[Christian @ 2CT Media]

If you want a very simple answer and easy way to program excel, Figure out your base rate and use IF THEN statements for example:

IF SqFt =< 10 Then BaseRate * 7, ELSE IF SqFt =< 50 Then BaseRate * 6... so on a so forth. This is more VBA termanology but I can put it into excel terms for you once I see you sheet.

 

[Christian @ 2CT Media]

You can email it to me if its easier: christian@2ctmedia.com

 

[Christian @ 2CT Media]

Here is a fast sample

 

[nashvillesigns]

PERFECT.



chris

 

[Christian @ 2CT Media]

no problem... good luck with your project!

There are other advanced options you can use to including drop downs, page call outs, and etc.

 

[Christian @ 2CT Media]

The other thing you may want to consider is writing an auto execute macro which would be ultimately faster and can have much more advanced features depending on your needs.