Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 23 January 2022
  1 Replies
  2.8K Visits
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. 
11 months ago
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:

  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - | 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