See if this works, =IF(A1>0,A1*100,1)
On Wednesday, November 24, 2021 at 11:05:41 PM UTC+5:30 [email protected] wrote: > 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/fa88cf9c-34c1-48c7-88db-f6fbd491e9aan%40googlegroups.com.
