I want to use if statements to determine the size of a value, and then multiply it by a certain amount.
For example. If A1 is <10 then * 2 If A1 is >10 and <50 * 1.5 If A is > 50 then * 1.25 Etc I also would like to preform this function with an entire column. Will =ARRAYFORMULA work with If statements? -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
