If Statement

[GRS]

I have records in one spreadsheet. All of the records are orderline
and give the product number, description, quantity and price of th
product.

So, for example…

Prod Ref Desc Qty Unit Cost
AAA Product A 2 2.50
BBB Product B 1 3.50


And so on.

However, when a discount has been applied against a product, th
discount amount is inserted as a new line as so

Prod Ref Desc Qty Price
AAA Product A 2 2.50
AAA Discount 0 -1.00
BBB Product B 1 3.50


I have set up my spreadsheet so that it now looks like this..

Prod Ref Desc Qty Price Cost Discount Price after Discount
AAA ProductA 2 2.50 5.00 -1.00 4.00
AAA Discount 0 -1.00
BBB Product B 1 3.50 3.50 0 3.50

Where I have, in the discount field, written the forumula that check
the price column one cell below and if this is a negative amount, t
put that amount in the discount field. If the amount is not negative
to put 0 in the discount field.

I then cut and paste this spreadsheet into a master spreadsheet
However as the orderline has already taken into account the discoun
line, I no longer want this line in the master. Also, I have inserte
the correct number of orderlines per order on the master spreadshee
and the number of lines don’t include the discount lines.

Is there a way of saying ‘if the price cell is less than 0, hide th
row’. But then when I cut and paste it to the master, I don’t want i
to copy the hidden rows.

Sorry for the long question – had to write it all out to check what
was asking!

Thanks again.

Gil

 

[Dave Peterson]

It sounds like you'd be happy with applying Data|filter|autofilter.

Then you could use a custom filter and show only those values greater than 0
(or greater than or equal to 0).

Then select your range and copy those visible cells.
Then Paste to whereever you want.