Jump to content

Work Sheet Question


Recommended Posts

Good morning,

Just a quick question. I have made this custom size counter top and i would like to have a work sheet to automaticly spit out a cost of the counter top based on square footage. Im haveing trouble with my formulas, maybe somebody could help me out. the counter is 72 5/8" x 21" and i charge $60 a square foot. This would be very helpful because i plan on having more custom counter tops with different sizes in my drawing, but i just want to start with one until i figure this out.

Thanks for your help

Link to comment

Hi kurt7717,

If you give your counter a name (eg. 'Kitchen Counter'), then when you are in the spread sheet you can use:

=AREA(N='Kitchen Counter')/144*60

The /144 assumes your drawing is in inches and will convert from sq in. to sq ft. The *60 you should recognize as your price/sq ft.

HTH,

Raymond

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...