I'm trying to automate some of the math in a keyword research database and I'd appreciate any help I can get.
I want to have the formula look at a column and if there is a value greater than 0 then multiply that value by 100. If there is a 0 or no value then I want it to fill in the number 1. I've tried SUMIFS, IFS, IFNA, and a whole bunch of other functions but I just can't figure out how to communicate what I want to the spreadsheet. Thanks! -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/4a2714e4-c836-4eae-b368-6024242aa86an%40googlegroups.com.
