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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!