I have a workbook that has a list of part numbers & Qtys. It looks up
the cost from 3 different Mfg product line lists and returns the cost
in 3 different columes. Now I need to multiply the Qty. x the cost but
I only want it done for 1 colume. Some of the pn's are in 1,2, or 3 of
the columes. I use IF(ISNA) to put 0's in when it's not on one of the
lists. Some Pn's are used in 1 or more lines & some are not. So far
I've not come up with a good formula. Thanks in advance for any ideas.
PN qty cost1 cost2 cost3 total cost
111 2 1.00 0 0
222 1 0 1.00 0
333 3 1.00 1.00 0
444 2 1.00 1.00 1.00
--
rbell
Posted via http://ms-os.com Forum to Usenet gateway
Bookmarks