creating a calculator
 

Excel 2003
I have two lists of parts, each with a different price. I want to be able to
enter a part number add it to another part number and get the total cost. It
needs to be brief and not overly complex and invlove filtering etc. The guys
in the workshop want to just type in the two part numbers and have the final
cost invloved diplayed. It sounds easy but I'm no expert using excel so all
help would be appreciated
Thanks

creating a calculator
 

Let's say you have a table in A:B, with column A listing all your part
numbers and column B listing prices.

If C2 is your first p/n, and C3 is your second p/n, the total is:
=IF(ISBLANK(C2),0,VLOOKUP(C2,A:B,2,FALSE))+IF(ISBL ANK(C3),0,VLOOKUP(C3,A:B,2,FALSE))

If you want to get a little fancy and have quantity called out in D2 and D3,
your total cost would be:
=D2*IF(ISBLANK(C2),0,VLOOKUP(C2,A:B,2,FALSE))+D3*I F(ISBLANK(C3),0,VLOOKUP(C3,A:B,2,FALSE))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"bearing man" wrote:

Excel 2003
I have two lists of parts, each with a different price. I want to be able to
enter a part number add it to another part number and get the total cost. It
needs to be brief and not overly complex and invlove filtering etc. The guys
in the workshop want to just type in the two part numbers and have the final
cost invloved diplayed. It sounds easy but I'm no expert using excel so all
help would be appreciated
Thanks