Simple Simple Simple

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

--
Message posted from http://www.ExcelForum.com

0
8/29/2004 2:38:16 AM
excel.newusers 15348 articles. 2 followers. Follow

3 Replies
1323 Views

Similar Articles

[PageSpeed] 44

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


>-----Original Message-----
>Just started Excel (again) and need to make an easy 
speadsheet for
>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 the
>total (sum) be entered into columns C and D.
>
>I can't believe I forgot how to enter formulas.  Any help 
will be
>appreciated.
>
>Thank you,
>Craig
>

0
anonymous (74722)
8/29/2004 3:43:53 AM
Thank you very much Don.  Everything works good.  I'll be adding som
other fields to it in the future.

Thank you again,
Crai

--
Message posted from http://www.ExcelForum.com

0
8/29/2004 4:04:19 AM
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

>-----Original Message-----
>Thank you very much Don.  Everything works good.  I'll be 
adding some
>other fields to it in the future.
>
>Thank you again,
>Craig
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
anonymous (74722)
8/29/2004 4:32:14 AM
Reply:

Similar Artilces:

Simple Formula Excel 2003
Can anyone give me some suggestions as to resolve a problem I want to create a formula that can be dragged down without using a macro For all you Excel gurus this is rather a pathetic question but I do not seem to be able to solve it What I want to do in cell c1 = sum(a1:a7) c2 = sum(a8:a15) c3 = sum(a16:a23) c4 etc etc Can anyone point me in the right direction Thanks Brian Scotland Well that depends... Are you summing a repeating set of: 7 cells, 8 cells, 8 cells ? -or- The set size is always 8 cells ? If the latter then use: =SUM(OFFSET($A$1,(ROW()-1)*8,0,8,1)) -- Jim Cone Portland...

Im looking for an answer to a very simple QUESTION!!! Please help
Hello, im 22 looking for a used car loan and will needing my dad to cosign for me which he has excellent credit. Is it possible for the dealer to give me the APR he qualifies for? Or much higher because of me??? Thanks EVERYONE Your dad would have to be the first person on the loan, you as the co-signer .... only original borower gets the good apr Jason "gabe c" <gabecz7@msn.com> wrote in message news:%23eJo%23UlwEHA.3088@TK2MSFTNGP12.phx.gbl... > Hello, im 22 looking for a used car loan and will needing my dad to cosign > for me which he has excellent credit. Is i...

This should be simple
I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not contain values. If only one of the cells contains a value, I want this value to appear in B1. How can this be done? -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34730 View this thread: http://www.excelforum.com/showthread.php?threadid=557388 If they are all all numbers: =IF(COUNTA(A1,A3,A5,A7,A9,A11)<>1,"not exactly one!",SUM(A1,A3,A5,A7,A9,A11)) (summing empty cells wo...

Conditional Formatting macro: simple, but doesn't work
Conditional Formatting macro: simple, but doesn't work. Using Excel 2007 with Windows 7. Enter the number 1 in cell A1 and the number 2 in cell B1. Start the macro recorder. Select A1:B1. Click Conditional Formatting, New Rule, Use a formula. Enter: =$a1<>$a2, Format, Border, select a continuous bottom border, OK, OK. Select cell B1 (only). Click Conditional Formatting, New Rule, Use a formula. Enter: =B1<>C1, Format, Font, Color, select red, OK, OK. Stop the macro recorder. Everything looks perfect with a line under cells A1:B1 and red font in cell B1 (o...

Another simple formula??
a1= $2.73 b1=2 c1=6.5% d1=$5.89 Very simply I want to take the unit price (a1) * Qty (b1) and add the sales tax (c1) and have the result in one cell (d1). I can do it with helper column but would rather not. The answer should be $5.89. (d1) Tx wabbleknee, Your D1 figure is wrong. It should be in the $5.81 or $5.82 range based on how you rounded the result. Choose from the following formulas, and place one in Cell D1, drag and fill down the rest of the column: =ROUND(SUM($A1*$B1,$A1*B1*$C1),2) =ROUND(($A1*$B1)*(1+$C1),2) Will give you $5.81 =ROUNDUP(SUM($A1*$B1,$A1*B1*$C1),2) ...

HowTo: Reduce "memory footprint" of simple app?
I'm developing a relatively simple MFC SDI app that has an objective of working well on "dinosaur" computers (old Pentium or 486, minimal memory, Win95, VGA resolution). MFC apps seem to have a default minimum memory allocation of about 4 megs, regardless of whether the app does much of anything. With Win2000 and and WinXP, the TaskMgr indicates that a wizard generated SDI app is allocated about 3.7 to 4.0 megs. My impression is that it is possible to set an option for the linker, or make a call to the o/s to relinquish quite a bit of this memory. However, I haven't found t...

simple xml for states list
Hi, Quick Question: How to create a simple XML with US States list and read it into a combo box. Detail: I am very new to Dot Net technology as well as xml. I am building a desktop app in C# and need to populate the US States list (AL, AR, .. WY) in a combo box. I could have done it by reading from a table in SQL server but rather prefer to have that list saved locally at client side as an xml and read it from there. what is the simplest way to go about it, what should be the structure of xml document and do i need schema also ? thanks for any response Aamir My answer for (almost) everyth...

simple query changing set of numbers from positive to negative
have a string of numbers in a column that are positive and would like to make negative ie 1384.40 128.31 193.7 .... and would like to make place minus in front ie -1384.40 -128.31 -193.7 .... Appreciate advice Sammy Put -1 in an empty cell, copy it, select the numbers and do edit>paste special and select multiply -- Regards, Peo Sjoblom "sammy" <sammy@bigpond.net.au> wrote in message news:NsXce.35124$5F3.2624@news-server.bigpond.net.au... > have a string of numbers in a column that are positive and would like to > make negative > > ie > > 1...

convert dual core to quad core is simple
do you people know there is a very easy way to convert your dual core into a quad and its inexspensive what are you smoking, kid? jaguarxj6 wrote: > do you people know there is a very easy way to convert your dual core into > a > quad and its inexspensive You have not heard of the old "Duct tape one CPU on top of the other trick". PA Bear [MS MVP] wrote: > what are you smoking, kid? > > jaguarxj6 wrote: >> do you people know there is a very easy way to convert your dual core >> into a >> quad and its inexspensive >...

Simple problem from a simple man
Hi,I have a table which records several different scores for eachrecord / entry. Is there a way that the report based on the query , inturn based on the table, will show the scores below a certain level ina different coloured font?Cheers,TC...

probably very simple
I'm trying to set up a simple spreadsheet of medical expenses. I'd like to be able to type a doctors name into one cell and automatically have excel enter the mileage into another cell. I know I'd have to put the information in somewhere, but I just don't know where to start. Combined, our family of 5 has about 6 doctors/specialists that we see on a regular basis, so this shouldn't be too difficult (I hope). Thanks in advance for any help. Hi to give you a starting point: 1. Setup a table with the doctor names and the mileages. Lets call this sheet 'data'. It...

Help with a simple print macro
Guys, I have inherited a spreadsheet with a macro built in. The macro is in a sheet and simply prints the next worksheet in the book. However, I've changed just one thing in the sheet to be printed, I've protected it. Now I get the message 'you cannot use this message on a protected sheet' When i depress the debug button it highlights 'Set rng = WS.Range("A1").CurrentRegion '<<< Change' as being the problem. Can this be resolved ? -- Eee One way would be to modify your macro to first "unprotect" the sheet, then do your prin...

Running a simple batch file at startup
The CMOS battery is gone bad in my Windows XP machine. Whenever Windows starts, I want to run the 'Date' command to set the current date. How do I accomplish this? Thanks in advance. -samah On Thu, 19 Nov 2009 06:41:38 +0530, samah <samah@mymail.com> wrote: > The CMOS battery is gone bad in my Windows XP machine. > > Whenever Windows starts, I want to run the 'Date' command to set the > current date. How do I accomplish this? Why don't you simply want to replace the battery? It's easy to do and extremely inexpensive (two or t...

Q: simple Access to Word mail merge
I'm using Access 2003 to mail merge to a Word 2003 doc. Below is the code that I modified from the microsoft website. ========================= Dim strWordDocName As String Dim objWord As Word.Document Dim strTableName As String strTableName = "MAILMERGESUBSET" strWordDocName = "S:\PATH\MailMerge.doc" Set objWord = GetObject(strWordDocName, "Word.Document") objWord.Application.Visible = True objWord.MailMerge.OpenDataSource _ Name:=CurrentProject.FullName, _ linktosource:=True, _ Connection:="QUERY MAILMERGESUBSET", _ ReadOnly:=Tr...

Simple encryption solution
I'm looking for suggestions for encrypting/decrypting strings. In the app, there is a (potentially huge) unicode string which is an entire xml file, ready to be written to disk. I'd like to encrypt it with a user-supplied password, write it to a file, and later read the file and decrypt it (in memory). Post decryption, it will be run through an xml parser. All the encryption solutions I've run into seem overly complicated for such a basic task. Suggestions? On May 15, 12:03=A0am, ab` <a...@absent.com> wrote: > I'm looking for suggestions for enc...

Am confused about a simple data layout- need help asap!
This is really silly, because I am good at charts, but for some reason, I cannot formulate in my head the proper layout of this chart. Here is what I have/need: THESE ARE MY DATA HEADERS: A B C D E F PERSON JOB 1 JOB 2 JOB 3 TOTAL ARBITRARY 1-3 NUMBER THE DATA LOOKS LIKE THIS: A B C D E F NAME1 3 2 8 ...

Simple Delete Query
I have a table that includes the field titled "State". I want to delete all records in a table except records that have "AZ", "CT" or "NY" in the state field. I have tried the criteria of =Not "AZ" or"CT or "NY", but I'm not getting the correct results. I only retain AZ records. Any help you can provide is appreciated, thank you. "SITCFanTN" <SITCFanTN@discussions.microsoft.com> wrote in message news:845CAAD2-8B83-4335-9CB4-A29A9E9D6F37@microsoft.com... >I have a table that includes the fiel...

Simple loop question
Hello, I have a control that has a number in it (e.g. 5) I need to repeat a task for the of time in my control. I guess it should be something like Dim MyCounter as long MyCounter = me.counter Do while myCounter = 0 ....do something mycounter = mycounter -1 loop Thak you, Silvio Change the "Do while myCounter = 0" line to: Do while myCounter > 0 ----- HTH Mr. B http://www.askdoctoraccess.com/ Doctor Access Downloads Page: http://www.askdoctoraccess.com/DownloadPage.htm "Silvio" wrote: > Hello, I have a control that has a...

Simple chart
On my excel worksheet, I have two columns. In column A1 I have the title "YEAR" followed by various years like 1994, 1995, etc, and in B1 I have the title "AVERAGE", followed by values for each year. I highlight A1:B12 and do the chart wizzard and get a bar chart which spreads the value of both year and averages. The X axis is just a consecutive number and the y axis spreads the values of years and averages. What I want is a chart where the X axis to displays the years from the A column and the Y axis to displays the numbers from the B column. How do I do this? Tha...

Need help with a simple query
Hello, I need help with this problem. I have two lists of dates. I am using a table as a filter for this list. What I want to do is create a final listing of all dates that are less than the minimum date in the filter. This is probably easier to demonstrate than to explain: Data: 1/3/2007 1/2/2007 1/1/2007 12/31/2006 12/30/2006 12/29/2006 Filter(Table) 2010 2009 2008 2007 Essentially, I want to display the MAX value from Data that's year is less than the minimum value of Filter(Table). The result should be 12/31/2006 Thanks! SELECT Max(data_field) AS max_date FROM data WHERE Ye...

Simple(?) Outlook / Exchange question
I'm using Outlook 2003 with Exchange 2003 for my e-mail. I have however a number of e-mail addresses, such as ebay@domain.com, misc@domain.com, etc. When composing a new email in Outlook (and sending it via the Exchange Account), how can I specify which address the From field should be set to? I know I can create additional accounts, but these require SMTP addresses for the outgoing servers. Thanks. Set the address in the From field -- Roady [MVP] www.sparnaaij.net Microsoft Office and Microsoft Office related News Also Outlook FAQ, How To's, Downloads and more... Tips of the mo...

Ordering results, not as simple as it sounds
Hey Everyone, first my disclaimer...not my design, inherited, so please don't complain about table structure, I already know. Thanks...onward. There are 2 tables First table holds time-keeping data (just the important stuff listed) Job Number (Number, Long Int.) Operation (Text, 50) Second Table shows the "Process Control" on a job...this is the ugly one Job Number (Number, Long Int.) Sequence01 (Text,50) Sequence02 (Text,50) .... Sequence17 (Text,50) I can get the query that shows the Job# and Operation from table 1, but I need all the gathered information to be in order a...

Can't solve simple? problem. Can some genius out there help!
Want to pull simple data from two tables/sheets into a third and use formulas (array or otherwise), not macros or filters. I only want to select rows for customer CARL. Below is the example: Table Deposits (First Table, one data source) Customer Date Deposit Carl 1/25/2008 $150,000.00 Carl 2/28/2009 $50,000.00 Joe 3/5/2008 Table Withdrawls (2nd Table another data source) Customer Date Withdrawl Carl 1/28/2008 (6000) Joe 3/1/2008 (3000) Carl 4/12/2008 (4000) Joe 5/5/2008 (7000) The desired final result is listed below. The column with the name CARL can be omitt...

simple excel question
I think this should be a simple question but for the life of me can't determine the best way to do it. I want to have a spreadsheet where the daily totals are entered to keep a running month to date and year to date total. I don't care about maintaining the daily input numbers. For example, Today's data MTD YTD 10 10 10 Now for tomorrow 20 30 30 And where is a date entered to determine which date is to be considered for MTD? -- Don Guillett SalesAid Software dona...

Simple hack to get $500 to your home.
Simple hack to get $500 to your home at http://uknews.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ...