Need Help Creating a Formula for EXCEL Closed

Question

I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that would read a certain text in a cell containing multiple words and that word will automatically correspond to a value to the next cell.

Example:
Let's say the word Ball is equal to 10, Toy is 15, and Bag is 5.

A cell will contain multiple text like:
Basket Ball 6" NYC

if the word "Ball" in cell A1, the value 10 should be in B1 or if the word "Bag" is in A1 the value 5 should be in B1.

Hope someone can help me. I would really appreciate your help.

ac3mark · Answer

If you are starting a business, start using QUICKBOOKS for your invoicing. Excel is not intended to make forms and run invoicing. 


But to answer your question, the IF is as stands:
=If(logic test, true, false)

So, in cell B1 enter:
=IF(A1="ball",10,IF(A1="Bag",5))  

This is a nested IF, and the second IF is built in the FALSE result.

Need Help Creating a Formula for EXCEL

1 response

Similar discussions

Subscribe To Our Newsletter!