Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an invoice from other worksheets
I have created a worksheet that allows me to enter a number and then
calculates the price based upon the items chosen. I am trying to create a customer invoice from this worksheet. It needs to pull the info only if the value is greater than 0. There are four separate cells for each line of the worksheet. Can you help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an invoice from other worksheets
"jodster" wrote:
I have created a worksheet that allows me to enter a number and then calculates the price based upon the items chosen. I am trying to create a customer invoice from this worksheet. It needs to pull the info only if the value is greater than 0. There are four separate cells for each line of the worksheet. .. It needs to pull the info only if the value is greater than 0. One way to cater for the above line is to use something like: =IF(OR(B2="",B2=0),"",VLOOKUP(B2, ...)) where B2 is the input cell For VLOOKUP and INDEX/MATCH usage & examples try Debra Dalgleish's pages at: http://www.contextures.com/xlFunctions02.html http://www.contextures.com/xlFunctions03.html Maybe try also Debra's sample files at: http://www.contextures.com/excelfiles.html Look for "Purchase Order" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I generate a new invoice number when creating new invoice? | Excel Discussion (Misc queries) | |||
Creating a Lookup Table on an Invoice? | Excel Discussion (Misc queries) | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
Master invoice number | Excel Worksheet Functions | |||
creating an invoice for work | Excel Worksheet Functions |