Are you stuck on Excel or Google Sheets?

Hi, I am just trying to modify the format within a string after a specific condition. For Example: If a specific value is found, then apply some specific format (bold, borders, etc)

I need to look up data from two different sheets. I need to reference data in one column on one sheet with data in one column on another sheet. Then if they match have a Yes filled in on a separate column in the second sheet.

If I merged a multi-row, multi-column selection. Iand types some text into the merged cell and then unmerges it, what will happen to the text?

I need a simple solution Bank balance - 7000 (1) Less unpresented Cheques - 500 (2) Add cheques lodged not credited - 200 (3) Total - 6700 (formula = 1+2-3 However if 2 is made 0 the total shows an error. Can we do a IF formula for the same please?

I use a Google Sheet to keep track of prospective investors. The first tab functions as a master tab. Some of the columns I use to categorize the prospects. For example, if they are a candidate to lead for the next round, in the column, I would put a y for Yes. Then, I would like to have a separate tab that shows only those investors that I have flagged as possible lead investors.

I need to auto populate stuff from one sheet to other linked sheet. e.g. If i enter something in one then it automatically populates in the next sheet. how i can do it

Hello - I am working on an IF function that has multiple conditions that I will need to use OR for. Ex) IF(Cell A1 = "Apple", "FRUIT","") OR (Cell A1 = "Broccoli", "VEGETABLE", "")

Working with two workbooks, the formula I need is going to look up the value in workbook 1 in a large range in workbook 2 (columns a-c and if it finds it and it meets a specific value in column 2, then bring back the value in column 3. How do I achieve this? Workbook 2 columns 2 and 3 are alphanumeric

I would like to have Excel look at a cell and if there is any # in it, to automatically add a new row below the current row and copy the previous row and paste it in the new row. If there is nothing in the target call, then do nothing. I dont know if it can do this, can it be done?

I am making a conversion chart. the formula I am using is =IF(C31<>0,(C31-29.7)/131.8+B31,""). This outputs to column D. This way, if column C is blank, the formula is ignored. If column B has a value, but column C does not, I want to ignore the formula and simply have column D equal Column B. If both C and B have a value, I want to run the formula which alters C and adds B.