November 28, 20223 yr Can anybody help me with this in Google Sheets? I used to be able to do it and now I can't remember how. I tried using the standard "if-then" formula but must be doing something wrong. I want a formula that will make cell 13 equal zero, if the sum of cell 14 + 15 is greater than 2,000. Assume the column is "A" for the purpose of giving me the formula. Thanks!
November 28, 20223 yr Do you use the Google Sheets API v4 by any chance? Or just the sheets themselves?
November 28, 20223 yr Author 4 minutes ago, ozimoron said: Does this help? https://spreadsheetpoint.com/google-sheets-if-then-formula/ Thanks but that I was using something similar and I just couldn't get it to work. I remember it was a very simple formula. I must be making a syntax error but I can't figure where, so hoping somebody can just write it out for me so I can plug it in.
November 28, 20223 yr Author 5 minutes ago, ozimoron said: Do you use the Google Sheets API v4 by any chance? Or just the sheets themselves? What ever is at https://docs.google.com/. I really am not an expert with the specifics of Google Sheets, but I'm pretty sure the formula is more or less universal, and I remember it was very simple.
November 28, 20223 yr 1 minute ago, Lemsta69 said: What do you want it to display if the sum of 14 and 15 is less than 2000? My guess is don't do anything with row 13 in that case.
November 28, 20223 yr 6 minutes ago, ozimoron said: My guess is don't do anything with row 13 in that case. Then it would be =IF((A14+A15)>2000,0,"")
November 28, 20223 yr I think it should be =IF((B14 + B15) > 2000, 0,) Note final comma, that should preserve the original content in cell 13 if the intention is not to modify it. https://webapps.stackexchange.com/questions/142985/is-there-a-way-to-get-the-if-statement-to-output-nothing-if-it-returns-false
November 28, 20223 yr If anyone does use Sheets API v4 I wrote an extensive library in ruby if anyone wants it for zip.
November 29, 20223 yr 17 hours ago, ozimoron said: I think it should be =IF((B14 + B15) > 2000, 0,) Note final comma, that should preserve the original content in cell 13 if the intention is not to modify it. https://webapps.stackexchange.com/questions/142985/is-there-a-way-to-get-the-if-statement-to-output-nothing-if-it-returns-false Thanks, very useful tip. Excel user because of my old job so still getting used to Sheets (I use it on my phone for fairly simple calculations).
.thumb.jpeg.108eb73d325ad9a507d6b8594b5c0f4a.jpeg)
Create an account or sign in to comment