A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

hard to explain in one line



 
 
Thread Tools Display Modes
  #1  
Old March 7th, 2009, 04:23 AM posted to microsoft.public.excel.newusers
Mike Stewart[_2_]
external usenet poster
 
Posts: 23
Default hard to explain in one line

I have a workbook called invoice, in it I have two tabs called invoice 1 and
invoice 2.
I have another tab called flat glass calc. My problen is this jezzz I hope I
don't get every confused.

flat glass calc tab has several formules, example

A B C D E
35 35 =X1.44 Cx $1.50 = $ amount to charge customer

Size X Size X 144=sq ft Sq X $1.50X 0.0825% tax= amount to customer
I have this the way I need it.
I also have the same formula to give me my cost + tax = tot, ant it works
off the same as the customer formula. Here is what I need to know.
I want to print two invoices ,,,, invoice will show the customers figures
and then it will also print on invoice 2 the actual cost.
I need to know the formula to transfer the from sheet flat glass calc to
invoice 1 , I think I figure the rest out.
Please e-mail me if more info is needed at

Thanks

  #2  
Old March 7th, 2009, 10:38 AM posted to microsoft.public.excel.newusers
FloMM2
external usenet poster
 
Posts: 189
Default hard to explain in one line

Mike,
If the numbers are in inches.
35 inches times 35 inches = 1225 sq in
1225 sq in * (1 sq ft/144 sq in) = 8.50 sq ft
cell D would be "=C2 *$1.50"
cell E would be "=D2 + (D2*0.0825)"

If you have the room on your spreadsheet -
add a column for sales tax, that way if it changes you can change one cell
instead of whole formula.
in cell E1 put in sales tax value (0.0825)
In cell F1 put "=D2 + (D2*$E$1)"
The "$" will lock the cell so you can copy down without it changing.

hth
Dennis

"Mike Stewart" wrote:

I have a workbook called invoice, in it I have two tabs called invoice 1 and
invoice 2.
I have another tab called flat glass calc. My problen is this jezzz I hope I
don't get every confused.

flat glass calc tab has several formules, example

A B C D E
35 35 =X1.44 Cx $1.50 = $ amount to charge customer

Size X Size X 144=sq ft Sq X $1.50X 0.0825% tax= amount to customer
I have this the way I need it.
I also have the same formula to give me my cost + tax = tot, ant it works
off the same as the customer formula. Here is what I need to know.
I want to print two invoices ,,,, invoice will show the customers figures
and then it will also print on invoice 2 the actual cost.
I need to know the formula to transfer the from sheet flat glass calc to
invoice 1 , I think I figure the rest out.
Please e-mail me if more info is needed at

Thanks

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.