Jump to content

Recommended Posts

Posted

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.

 

image.jpeg.016aaeeaf71ed9bcbed480912b7619a7.jpeg

 

Thanks!

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

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

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

  • Thumbs Up 1

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.



×
×
  • Create New...