Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 20th 07, 11:26 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 21
Default Order Sheet Excel Setup

Hi

I have a basic Excel Spreadsheet which lists items in one column and
then their price in another column and then the quantity, it then
totals up the row and finally at the bottom totals to rows to give a
Full and Final Amount to be charged. This goes out to our customers
and they basically use it like a shopping pick list which is great.
However, some items are now FOC (typical) so I need to insert another
column and say mark "x" in the particular row if the item is FOC, how
can I get this to reflect in the total row amount to show 0.00.

Columns
Qty, Item, Price, discount, Line Total

Thanks

  #2   Report Post  
Old December 20th 07, 12:20 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Order Sheet Excel Setup

=IF(E2="x",0.00,your_existing_formula)
--
David Biddulph

" wrote in message
...
Hi

I have a basic Excel Spreadsheet which lists items in one column and
then their price in another column and then the quantity, it then
totals up the row and finally at the bottom totals to rows to give a
Full and Final Amount to be charged. This goes out to our customers
and they basically use it like a shopping pick list which is great.
However, some items are now FOC (typical) so I need to insert another
column and say mark "x" in the particular row if the item is FOC, how
can I get this to reflect in the total row amount to show 0.00.

Columns
Qty, Item, Price, discount, Line Total

Thanks


  #3   Report Post  
Old December 20th 07, 01:16 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 21
Default Order Sheet Excel Setup

On Dec 20, 11:20 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=IF(E2="x",0.00,your_existing_formula)
--
David Biddulph

" wrote in message

...
Hi

I have a basic Excel Spreadsheet which lists items in one column and
then their price in another column and then the quantity, it then
totals up the row and finally at the bottom totals to rows to give a
Full and Final Amount to be charged. This goes out to our customers
and they basically use it like a shopping pick list which is great.
However, some items are now FOC (typical) so I need to insert another
column and say mark "x" in the particular row if the item is FOC, how
can I get this to reflect in the total row amount to show 0.00.

Columns
Qty, Item, Price, discount, Line Total

Thanks


Thats has worked perfectly, many thanks


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
How do I setup in Excel an 11 X 17 work sheet? jimh Excel Discussion (Misc queries) 2 October 25th 07 08:09 PM
Setup Purchase Order Template to have a automatic number system? LynnB Excel Worksheet Functions 2 July 19th 06 03:08 AM
Excel page setup Sheet Print Cells Error As... tikchye_oldLearner57 Excel Discussion (Misc queries) 2 May 16th 06 04:29 PM
Change Excel sheet order KeithS Setting up and Configuration of Excel 1 February 19th 06 03:45 PM
How can i setup tab order of cells the way i want them? MRD Setting up and Configuration of Excel 1 May 12th 05 08:38 PM


All times are GMT +1. The time now is 12:01 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017