User Profile
Meddie1938
Copper Contributor
Joined Jan 15, 2023
User Widgets
Recent Discussions
Re: Using "if" & "and" functions
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!1.3KViews0likes1CommentRe: Using "if" & "and" functions
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!1.3KViews0likes0CommentsUsing "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 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.1.5KViews0likes5Comments
Recent Blog Articles
No content to show