Google Spreadsheet Post #1728

*Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug-14-2014**post by Jennifer Kaupke:**(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/-jcCcnyAmwI)*

*How can I set my spreadsheet to subtract one cell from another cell only when there are values in both cells? For example, when I enter data into the first cell and not the second I end up with a negative number and when I don't enter a value in either cell, the cell with the formula displays a "0". Is there a way to write formula so it will only subtract once I enter a value into the second cell. I am including a screen shot of part of my spreadsheet - as you can see I am working on a spreadsheet for teachers that will calculate data for their classroom. The 0's and negative numbers are distracting to the eye and are unnecessary.*

*This is probably a simple question but I am new to writing formulas. Thanks for your help! :)*

*Attachments (1)*