Forum Discussion
Meddie1938
Jan 16, 2023Copper Contributor
Using "if" & "and" functions
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...
Harun24HR
Jan 16, 2023Bronze Contributor
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.
- Meddie1938Jan 17, 2023Copper ContributorI now find that I must search for the word "roll" AND "spread" in B2 to operate on. Could you be so kind as to give me the scrips or code for that. Thank you in advance
- Meddie1938Jan 16, 2023Copper ContributorWhat you suggested worked just perfectly. One follow-up question. If I should want to multiply my formula by a formula in another cell would I simply replace the multiplier ( in this case 2) with the other formula? Thank you so much for the help Harun24HR!