title: How to calculate the loss if the value is equal to 0 in Google Sheets
body: <p>I want to calculate the loss if the value is equal to 0 in Google Sheets, for example in the screenshot I attached, if I don't get any sales, so I want to see -$10 in Profit Per Unit cell.</p>
  
  <p>Any solution and tricks to get this function works.</p>
  
  <p><a href="https://i.stack.imgur.com/zS7bo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zS7bo.png" alt="Here&#39;s an example"></a></p>