Need Help Creating a Formula for EXCEL

Closed
Report
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
-
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
-
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.

1 reply


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.
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017

I already did that same formula, but the problem is because there are multiple words in the cell the formula is not working.
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017

BTW, thank you for your help. I tried removing other words in the cell and just left the word "ball" and it showed me the corresponding value in B1.

I guess the question I wanted to ask was, is there another function that I can add to the formula to look for the specific word in the cell like SEARCH or FIND and still produce the right value in B1.