Previous Topic Next Topic

Need Help Creating a Formula for EXCEL

Closed
five2588
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
 - Jul 5, 2017 at 03:09 PM
five2588
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
 - Jul 5, 2017 at 05:05 PM
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

Answer 1 / 1
Blocked Profile
Jul 5, 2017 at 04:10 PM
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.
0
five2588
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
Jul 5, 2017 at 04:58 PM
I already did that same formula, but the problem is because there are multiple words in the cell the formula is not working.
0
five2588
Posts
3
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
Jul 5, 2017 at 05:05 PM
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.
0