Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

Can I create a formula in microsoft excel where a name ...

Sent to Computer Experts February 01 10:23 AM

Can I create a formula in microsoft excel where a name equals a dollar value? For instance when making an invoice where part ABC is $1.00 and part XYZ is $1.35 can I type ABC in a cell and it will add $1.00 in another cell to calculate the total price for 500 pieces

 

Optional Information:
Browser: IE

Customer (name blocked for privacy)
Status:  Closed   Value: $9
Answer
February 1 10:36 AM (12 minutes and 37 seconds later)
         
REPLIEDCheck Mark

Hi,

You can type ABC in say cell F9, and have a formula in cell G9 to read F9 then it looks for the value of ABC in the main parts table, gets its price, adds $1 to it, and calculates the price for 500 pieces. All in cell G9. Is this in line with what you want to do?

 



...If you found my answer helpful please click the ACCEPT button.
   Positive Feedback is greatly appreciated.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2190 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
February 1 10:51 AM (15 minutes and 37 seconds later)
         
Reply to John D's Post: Can you show me the formula for example 100 pcs.
Customer (name blocked for privacy)
Answer
February 1 11:01 AM (9 minutes and 51 seconds later)
         
ACCEPTEDCheck Mark

Sure.

Let's say the main parts table is in cells A1 through B20. And suppose Part Numbers are listed in column A, and the Unit Price are in column B. Now suppose you want to apply the formula in cell G9 for the part number entered in cell F9 as described before, here is the formula in G9:

=(VLOOKUP(F9,A1:B20,2,0)+1)*100

Let me know if you have any questions.

Hope this helps.

 

 

 



...If you found my answer helpful please click the ACCEPT button.
   Positive Feedback is greatly appreciated.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2190 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
February 1 11:04 AM (2 minutes and 41 seconds later)
         
I think that answers my question. I'll try it.
How can I contact you again if I need more help?
Customer (name blocked for privacy)
Answer
February 1 11:07 AM (3 minutes and 26 seconds later)
         
REPLIEDCheck Mark

Just come back to this question page. You should have a link to this page in the email notification that you have received from just Answer, or you can book mark this page.

 



...If you found my answer helpful please click the ACCEPT button.
   Positive Feedback is greatly appreciated.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2190 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
February 1 11:51 AM (43 minutes and 21 seconds later)
         
Reply to John D's Post: THE FORMULA WORKS!!!!!! THANKS. CAN YOU EXPLAIN WHAT THE ,2,0)+1)IN THE FORMULA REPRESENT?

=(VLOOKUP(F9,A1:B20,2,0)+1)*100
Customer (name blocked for privacy)
Answer
February 1 11:57 AM (5 minutes and 49 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2190 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer and Software Help