Dear All, I have a question while using Google sheet. The problem is that, Column B need to show a negative number of Column A. And if the value is zero, show "-". How to type the formula and set the data format?
For the formula, I try A2=-1*(B2), it's okay, but if the cell is zero / empty, it show #VALUE!, how is setting so that i can show "-" if the value is zero? BR AL -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
