Re: If other cell is blank then do this math formula here, but if other cell not blank then copy it here

DevinT21 

If it's really not working, looking at it again, I think I'd change the 20% to a simple .2, so the revised formula would read =IF(J2="",SUM(F2:G2)*.2,J2)

I missed that the first time around, concentrating on the text aspect.