Noob help in google sheets

[sprunk]

Hey. Could someone please help me in google sheets. I am hopeless with spreadsheets.:) 

I am try to create a a basic spread sheet if I can use this as an example say I have a sheet where A1 is a value of 10. A2 is a value if 20. I want to create a formula in B2 which would be B2=A2-A1.Though when I drag the formula down then B3 will have negative 20 showing  cause there is no value in a3.and so forth. I want to know how to make that cell not display. I hope that makes sense.

[mariushm]

You could put the formula in another cell or a column that you can hide, and then put in that B column the number only if value is positive ... ex =IF (hidden_column >0 , hidden_column,  "")

 

 

 

[sprunk]

6 minutes ago, mariushm said:

You could put the formula in another cell or a column that you can hide, and then put in that B column the number only if value is positive ... ex =IF (hidden_column >0 , hidden_column,  "")

 

 

 

OK, Thanks I will give that a try