Order Sheet Excel Setup

[babypink2807]

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

 

[David Biddulph]

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

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

 

[babypink2807]

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


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