Note: The other languages of the website are Google-translated. Back to English
  Sunday, 23 January 2022
  1 Replies
  2.5K Visits
0
Votes
Undo
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. 
9 months ago
·
#2450
0
Votes
Undo
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
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL