Converting Liters to gallons

[skylinekiller]

I am trying to get the cell to convert liters to gallons. I don't always need to convert to gallons, some of my sells will have gallons and some will have liters. I can get the cell to convert, but my problem is how to get it to where it doesn't always convert if there is a zero value in my liter column.
My formula is =convert(E2,"l","gal")

Liters Gallons
E2 G2
4 1.056688
3 .792516

 

[Joe4]

Do you mean like:

=IF(E2>0,convert(E2,"l","gal"),"")

 

[skylinekiller]

Yes, thank you, I knew I needed to use IF, just didin't know how. Thank you for solving my problem