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...
While this worked perfectly for me for the question I asked, I find the cell(s) with the script registers the word false if the condition is not meant. Since I really need to sum the columns of numbers, it appears I need to add the condition that if the word "spread" does not appear then use the existing formula, without the multiplier. Thank you again for the expertise!
Again your suggestion was right on. Thank you so much!