3

Is there a way to make this formula print empty cells based on the "F" column having no value? I'm currently getting the cell to return "0" but I want it to be blank as I'm trying to combine this manual input with a supermetric query. The purpose is to calculate the Avg. for that column and push it to data studio, if "0" exists the avg is wrong.

Formula:

=IFERROR(F2*GOOGLEFINANCE("CURRENCY:SEKGBP"),"")
player0
  • 124,011
  • 12
  • 67
  • 124
Filip
  • 33
  • 3

1 Answers1

1

try:

=IF(F2="",,IFERROR(F2*GOOGLEFINANCE("CURRENCY:SEKGBP")))
player0
  • 124,011
  • 12
  • 67
  • 124