Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 1st 06, 03:59 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default How To Create a Percentage Discount in Invoice

Hello!

I am very new to Excel and have downloaded a Sales Invoice Template (not
sure what it is called).

I have fields in this template for:
Quantity
Unit Price
Total
(going accross template)
Then at the bottom there are these fields:
Sub Total
Shipping
Tax Rate
TOTAL
What I would like is to have a Percentage Discount field for a $50% discount
before the shipping field.

Is there a way to do this and how can I do it.

Thanks!

  #2   Report Post  
Old September 1st 06, 04:18 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 299
Default How To Create a Percentage Discount in Invoice

Don't know if it is protected or not but assume that the discount is in H6
and the price before shipping in G6 then you can use

=G6*(1-H6)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hello!

I am very new to Excel and have downloaded a Sales Invoice Template (not
sure what it is called).

I have fields in this template for:
Quantity
Unit Price
Total
(going accross template)
Then at the bottom there are these fields:
Sub Total
Shipping
Tax Rate
TOTAL
What I would like is to have a Percentage Discount field for a $50%
discount
before the shipping field.

Is there a way to do this and how can I do it.

Thanks!



  #3   Report Post  
Old September 1st 06, 04:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default How To Create a Percentage Discount in Invoice

Hi Peo,

I see no letters at the top, there are just numbers at the top and along the
bottom.
But for the shipping field the number says: R37C13
I am not sure if this helps.

I am so sorry I can't be more specific. Like I said, I really haven't used
Excel much for calculating things

Is there a possibility that I could email the template to you to have a look
at? I am not sure that I am describing things correctly.

Thank you so very much!

"Peo Sjoblom" wrote:

Don't know if it is protected or not but assume that the discount is in H6
and the price before shipping in G6 then you can use

=G6*(1-H6)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hello!

I am very new to Excel and have downloaded a Sales Invoice Template (not
sure what it is called).

I have fields in this template for:
Quantity
Unit Price
Total
(going accross template)
Then at the bottom there are these fields:
Sub Total
Shipping
Tax Rate
TOTAL
What I would like is to have a Percentage Discount field for a $50%
discount
before the shipping field.

Is there a way to do this and how can I do it.

Thanks!




  #4   Report Post  
Old September 1st 06, 04:43 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 299
Default How To Create a Percentage Discount in Invoice

You are using R1C1 reference style, it's quite handy once you get the hang
of it but you are probably better of to do toolsoptionsgeneral and uncheck
R1C1

Anyway is it called Sales Invoice and the total column is yellow and the
rest (apart from the invoice) is dark green?
If so do toolsprotection and unprotect the sheet, now you could add
discount in there


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hi Peo,

I see no letters at the top, there are just numbers at the top and along
the
bottom.
But for the shipping field the number says: R37C13
I am not sure if this helps.

I am so sorry I can't be more specific. Like I said, I really haven't used
Excel much for calculating things

Is there a possibility that I could email the template to you to have a
look
at? I am not sure that I am describing things correctly.

Thank you so very much!

"Peo Sjoblom" wrote:

Don't know if it is protected or not but assume that the discount is in
H6
and the price before shipping in G6 then you can use

=G6*(1-H6)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hello!

I am very new to Excel and have downloaded a Sales Invoice Template
(not
sure what it is called).

I have fields in this template for:
Quantity
Unit Price
Total
(going accross template)
Then at the bottom there are these fields:
Sub Total
Shipping
Tax Rate
TOTAL
What I would like is to have a Percentage Discount field for a $50%
discount
before the shipping field.

Is there a way to do this and how can I do it.

Thanks!






  #5   Report Post  
Old September 1st 06, 05:03 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default How To Create a Percentage Discount in Invoice

Peo,

You are correct on the Sales Invoice (yellow colum, green background)

I have done what you suggested and unchecked R1C1 style and also uprotected
the sheet.

Under "M36" Sub Total I will add in a new Row for the Percentage discount.
That would make this cell: 'M37'.
Now I am figuring the calculation you gave me has something to do with the
cell number? If so, would I have to adjust this formula?: =G6*(1-H6)

Thanks so much for taking the time to help me out. I really appreciate it.



"Peo Sjoblom" wrote:

You are using R1C1 reference style, it's quite handy once you get the hang
of it but you are probably better of to do toolsoptionsgeneral and uncheck
R1C1

Anyway is it called Sales Invoice and the total column is yellow and the
rest (apart from the invoice) is dark green?
If so do toolsprotection and unprotect the sheet, now you could add
discount in there


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hi Peo,

I see no letters at the top, there are just numbers at the top and along
the
bottom.
But for the shipping field the number says: R37C13
I am not sure if this helps.

I am so sorry I can't be more specific. Like I said, I really haven't used
Excel much for calculating things

Is there a possibility that I could email the template to you to have a
look
at? I am not sure that I am describing things correctly.

Thank you so very much!

"Peo Sjoblom" wrote:

Don't know if it is protected or not but assume that the discount is in
H6
and the price before shipping in G6 then you can use

=G6*(1-H6)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"wambui" wrote in message
...
Hello!

I am very new to Excel and have downloaded a Sales Invoice Template
(not
sure what it is called).

I have fields in this template for:
Quantity
Unit Price
Total
(going accross template)
Then at the bottom there are these fields:
Sub Total
Shipping
Tax Rate
TOTAL
What I would like is to have a Percentage Discount field for a $50%
discount
before the shipping field.

Is there a way to do this and how can I do it.

Thanks!








  #6   Report Post  
Old September 1st 06, 11:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default How To Create a Percentage Discount in Invoice

Hello,

I am still not sure what to do.

What should the fomula be and where should it go?

Thanks!

"wambui" wrote:

Peo,

You are correct on the Sales Invoice (yellow colum, green background)

I have done what you suggested and unchecked R1C1 style and also uprotected
the sheet.

Under "M36" Sub Total I will add in a new Row for the Percentage discount.
That would make this cell: 'M37'.
Now I am figuring the calculation you gave me has something to do with the
cell number? If so, would I have to adjust this formula?: =G6*(1-H6)

Thanks so much for taking the time to help me out. I really appreciate it.



"Peo Sjoblom" wrote:

You are using R1C1 reference style, it's quite handy once you get the hang
of it but you are probably better of to do toolsoptionsgeneral and uncheck
R1C1

Anyway is it called Sales Invoice and the total column is yellow and the
rest (apart from the invoice) is dark green?
If so do toolsprotection and unprotect the sheet, now you could add
discount in there


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage Discount Ruth Excel Discussion (Misc queries) 3 July 20th 06 02:35 PM
Percentage Discount Total mdj101 Excel Discussion (Misc queries) 1 May 18th 06 04:33 PM
Create semi-log plot for percentage galgocid Charts and Charting in Excel 1 December 21st 05 04:23 PM
i need to create an invoice that will flag up when not paid bgc1416 Excel Discussion (Misc queries) 2 November 9th 05 03:04 PM
How do i create a Wrksht that auto. chgs to nxt invoice # when ope Holly Excel Discussion (Misc queries) 2 November 8th 05 04:33 PM


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017