contains a certain word

Hi! I have 2 columns. Column A - Amount ($) all in absolute values Column B - Status (either named as Accepted / Cancelled) In excel, we could input a formula =IF(B1="Cancelled",-A1,A1) Can this be done in Powerquery? If so, how would I do this? Thanks!

Hi all, I have this example: A B C D E TRAILING SADDLE BAG BAG 555 SHOE 333 My goal is to enter a formula in B1 cell to look for text inside A1 cell from list in D column, and when/if it finds the text then paste the text from E column. So the formula...

I am trying to do a comparison of uneven columns of text to see if the other column contains a match. I want to make it not case-sensitive. I have tried doing an IF statement. Is there anything else you recommend?

Hello, I'm trying to create a VBA that states if within Column A if there is a text then paste to the right. If the cell in column A has a numeric value then do nothing. <tbody> a b 1 john 2 1 3 3 4 jake 5 bill 6 7 </tbody>

I am VERY new to vba and usually use record macro for repetitive functions but can't do so in this case so need some help with coding. My question was deleted from another question site so I'm going to try to do a better job explaining, as I would really love the coding to make this work. I...

Hello! I'm trying to write two different formulas that show the following: Typing in Cell B1...If Cell A1 contains "Apple" AND "Orange", but also DOES NOT contain "Banana" OR "Grape" OR "Pear", then return the value in cell D1, otherwise, return a blank. Typing in Cell C1...If Cell A1...

Hi all, Thank you for your help ahead of time! Below is my current code. My goal is to filter a very large pivot table (connected to an OLAP Cube) with a user defined keyword. The keyword is entered through a separate userform and stored in variable pdk1. When I run this code I get an overflow...

I could really use some help with a formula... it needs to return the number directly following substring "RX" within a string? For example if i have the string "12354165RX15" then just show "15". Another example is "165163546RX15_G_B" then it would still need to also just show "15". I have...