If someone can help, that would be great. I would like to use two different equations (K4*1.25) and (K4*1.18) that are selected based on the text in a different cell. For example, if cell B4 contains "Kitchen Cabinets" use (K4*1.18) but if it says anything else, use (K4*1.25). How can this be done? So far the best I can get it to do is populate the cell with my equation as though it is a text value, instead of actually using my equation as a formula like I want it to.
Hi Ryan$$Mith,
You can use the formula below:
=IF(ISNUMBER(SEARCH("Kitchen Cabinets",B4)),K4*1.18,K4*1.25)
To see how does it work, please click here to read the instruction: https://www.extendoffice.com/excel/formulas/excel-if-cell-contains-text-then-display.html
Amanda
You can use the formula below:
=IF(ISNUMBER(SEARCH("Kitchen Cabinets",B4)),K4*1.18,K4*1.25)
To see how does it work, please click here to read the instruction: https://www.extendoffice.com/excel/formulas/excel-if-cell-contains-text-then-display.html
Amanda
- Page :
- 1
There are no replies made for this post yet.