Forum Discussion

Todd444_64's avatar
Todd444_64
Copper Contributor
Jan 02, 2020

IF statement

Basically a simple Franchise order form for wine.  They have a list of wines and enter number of cases required in column D ie 2 cases.  I would like to take all those requests and place into an ordered sheet for printing purposes with none of the wines that had a zero response. And no blank lines.

 

IF statement...

 

 

Many thanks

 

 

excel

1 Reply

  • Alan_Murray's avatar
    Alan_Murray
    MVP
    Jan 02, 2020

    Todd444_64 It sounds like the simplest method would be to just Filter the list to exclude the blanks and zero response and then copy and paste the wines into the other sheet. Then sort them into the order you want for printing.

    I can't see the need for the IF function in this scenario.

Resources