Simple Simple Simple

[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

 

[Don]

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

 

[craigwojo]

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

Thank you again,
Crai

 

[Don]

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