Google Sheets Help: If-Then formula

[WaveHunter]

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!

[ozimoron]

Does this help?

 

https://spreadsheetpoint.com/google-sheets-if-then-formula/

[ozimoron]

Do you use the Google Sheets API v4 by any chance? Or just the sheets themselves?

[WaveHunter]

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.

[WaveHunter]

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.

Edited November 28, 2022 by WaveHunter

[Lemsta69]

What do you want it to display if the sum of 14 and 15 is less than 2000?

[ozimoron]

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.

[Slip]

=IF(B12+B13>2000,0,"X")  

 

Edited November 28, 2022 by Slip

[Lemsta69]

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,"")

[ozimoron]

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

 

 

Edited November 28, 2022 by ozimoron

[ozimoron]

If anyone does use Sheets API v4 I wrote an extensive library in ruby if anyone wants it for zip.

[Lemsta69]

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).