Forum Discussion

Copper Contributor

Sep 13, 2022

Solved

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

If other cell is blank, then do this math formula here. But if other cell is not blank then copy that here. For example, I have this formula: =IF(J2="","=SUM(F2:G2)*20%","=J2") but it is only copying...

excel

Formulas and Functions

mathetes
Sep 13, 2022
DevinT21

Take away the quotes (and the extraneous equals signs). You are ASKING it to do text by putting those statements in quotes.
You have =IF(J2="","=SUM(F2:G2)*20%","=J2")
Should be =IF(J2="",SUM(F2:G2)*20%,J2)

mathetes

Gold Contributor

Sep 13, 2022

DevinT21

Take away the quotes (and the extraneous equals signs). You are ASKING it to do text by putting those statements in quotes.

You have =IF(J2="","=SUM(F2:G2)*20%","=J2")

Should be =IF(J2="",SUM(F2:G2)*20%,J2)

DevinT21
Copper Contributor
Sep 13, 2022
Nevermind, I think it's working! Thank you!
- mathetes
  Gold Contributor
  Sep 13, 2022
  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.
DevinT21
Copper Contributor
Sep 13, 2022
Hi mathetes,

That does not work. It is giving me an error.