Forum Discussion
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...
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.
What 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!