With A1 representing the cell location, the formula is =IF(A10,A1,0)

"Penfold" wrote:

I need to create a formula that says if the value is a minus or 0 show 0.00
if there is a positive value show the value.