| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I setup in Excel an 11 X 17 work sheet? | Excel Discussion (Misc queries) | |||
| Setup Purchase Order Template to have a automatic number system? | Excel Worksheet Functions | |||
| Excel page setup Sheet Print Cells Error As... | Excel Discussion (Misc queries) | |||
| Change Excel sheet order | Setting up and Configuration of Excel | |||
| How can i setup tab order of cells the way i want them? | Setting up and Configuration of Excel | |||
![babypink2807@googlemail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
