Jan 15 2023 04:30 PM
So I have a mix of spreadsheet data, some with words and some with formulas. Can someone help me with the instruction entry I would make when I want to find all cells in a certain column, say column B, that contains the word "spread"; then multiply all the formula results contained in column M by the factor 2? Hope my question is not too confusing and thank you in advance for any help.
Jan 15 2023 06:18 PM
@Meddie1938 Try-
=IF(ISNUMBER(SEARCH("spread",B2)),(Your-Formula)*2,Your-Formula)
Replace the word Your-Formula with your actual formula used in M column.
Jan 16 2023 07:36 AM
Jan 16 2023 07:55 AM
Jan 16 2023 01:12 PM
Again your suggestion was right on. Thank you so much!
Jan 17 2023 08:19 AM