Simple Simple Simple

  • Thread starter Thread starter craigwojo
  • Start date Start date
C

craigwojo

Just started Excel (again) and need to make an easy speadsheet fo
calculating square inches.

Column A: Height
Column B: Legnth
Column C: Total Tags per 16 x 24
Column D: Cost per tag

Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches

What I want to do is enter the Height, enter the Length and have th
total (sum) be entered into columns C and D.

I can't believe I forgot how to enter formulas. Any help will b
appreciated.

Thank you,
Crai
 
Hi Craig,

One Way, might be better ways but this'll work:

List the coloumns as you posted. I also included the
$9.98 in cell F2.

First Row is for your headers.

In C2 enter:

=IF(OR(A2="",B2=""),"",FLOOR(24/A2,1)*FLOOR(16/B2,1))

drag this down as far as you need to.

In D2 enter:

=IF(C2="","",$F$2/C2)

Also drag down the same as above.

Be sure to enter $9.98 in F2 (this you can change if your
costs vary without going into the formulas.

HTH,

Don
 
Thank you very much Don. Everything works good. I'll be adding som
other fields to it in the future.

Thank you again,
Crai
 
Happy to return a little of the knowledge I've picked up
on here...glad it worked for you.

Thanks for the feed-back,

Don
 
Back
Top