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
five2588 Posts 3 Registration date Wednesday July 5, 2017 Status Member Last seen July 5, 2017 - Jul 5, 2017 at 05:05 PM
Related:
- Need Help Creating a Formula for EXCEL
- Excel date format dd.mm.yyyy - Guide
- Create a yahoo email account for free - Guide
- Number to words in excel formula - Guide
- Kernel for excel - Download - Backup and recovery
- Mark sheet grade formula in excel download - Guide
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.
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.
Jul 5, 2017 at 04:58 PM
Jul 5, 2017 at 05:05 PM
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.