I would use this formula instead =IF(A48>0,A48,"")
does exactly the same as the second one you have posted
as for the first one 0 is not an empty string it is a value thats why it will display

though im confused by your first sentence
"Trying to have a cell, lets say Sheet2 A1 = Sheet1 A1 using the following:"
as none of those formulas will do that