Return 0 when a value of a cell is negative

Posted by Robert on Stack Overflow See other posts from Stack Overflow or by Robert
Published on 2010-05-22T20:01:51Z Indexed on 2010/05/22 20:10 UTC
Read the original article Hit count: 128

Filed under:

google

|

google-spreadsheet

I have a google spreadsheet that uses this function:

=SUM(E:E) - SUM(C:C)

It adds up all the values of column E and column C and them subtracts the difference. I would like to be able to return a 0 if the difference is negative.

© Stack Overflow or respective owner

Related posts about google

Removing malware of a particular kind

as seen on Super User - Search for 'Super User'
I need to remove some malware from my computer. It is a trojan, and very annoying. It blocks access to Google and search sites. The trojan, with its name spelled out on each line cause it seems to block sites when i reference it in a url, is a r t (some text to mess it up) e m (more text i s First… >>> More
Trouble installing Matlab

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
So whenever I try to install Matlab, the first image appears, but then goes away and that's the end of it. Here's what I'm doing- user@host$> cd ~/mathworks_downloads user@host$> unzip matlab_R2012a_student_glnx86_installer.zip user@host$> ./install The Matlab logo and image pop up here… >>> More
Google chrome is always searching in local google domain instead of Google.com

as seen on Super User - Search for 'Super User'
I have changed in the searched preferences to google.com but still when I do search from the address bar (instant or non-instant) it will go to google.co.kr. Even though I change "Google.com in English", still same... The only way is to open google.com website first, then do search in it. So the… >>> More
Google I/O 2010: Google TV Keynote - Introducing Google TV

as seen on Google Code - Search for 'Google Code'
Google I/O 2010: Google TV Keynote - Introducing Google TV Due to licensing and permissions issues, we are unable to show the full Google TV demonstration from the Day 2 keynote at Google I/O. Until we are able to get these permissions, please check out these clips. For Google I/O session videos… >>> More
Google I/O 2010: Google TV Keynote - Android Apps On Google TV

as seen on Google Code - Search for 'Google Code'
Google I/O 2010: Google TV Keynote - Android Apps On Google TV Due to licensing and permissions issues, we are unable to show the full Google TV demonstration from the Day 2 keynote at Google I/O. Until we are able to get these permissions, please check out these clips. For Google I/O session videos… >>> More

Related posts about google-spreadsheet

Run Google-apps-script on Google-Spreadsheet event?

as seen on Stack Overflow - Search for 'Stack Overflow'
If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don't know if Google spreadsheet supports any events. For example: a Google app script that strikes out rows in the spreadsheet that have been marked completed by way… >>> More
Google Spreadsheet multiple column filter using OR

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Google Spreadsheet with 3 columns which are either blank or have a value. I want to get the count of the number of rows that has A and either B or C populated. If I were writing a SQL query it would be select count(*) from Table where A is not null and (B is not null or C is not null) But… >>> More
Google Apps Script - Sending Google Spreadsheet Row to Email

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to write a script using Google Apps Script (Javascript) for a Google spreadsheet. I am trying to do the same thing that is shown in this tutorial [http://www.google.com/google-d-s/scripts/sending_emails.html][1], but each row in my spreadsheet has 24 columns. I would like to send… >>> More
Using Google Spreadsheet API on Blackberry

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a Google spreadsheet synchronization feature on a blackberry application that I am building. Not being a pro I was hunting for some sample code to get a grasp of the flow but I could not. When I am using the API from Google to access spreadsheets, it suggests to use the SpreadsheetService… >>> More
Where is the script editor in google spreadsheet?

as seen on Super User - Search for 'Super User'
Hello I just stumbled upon this link and wanted to try it out. Yet, if I open a google spreadsheet, I have no scripts submenu under the tools menu. This was with firefox 3.0.15 and IE 7. Unfortunately, I didn't find anything that indicated why there wouldn't be such menus with my spreadsheets. Does… >>> More