Google-sheets – IF condition with ISBLANK using Google Sheets *driving me insane*

formulasgoogle sheets

I have a Google Sheet for investment tracking setup and I'm trying to add a ISBLANK to the following formula:

=IF(G67=TRUE,G12, G12*GOOGLEFINANCE(("CURRENCY:USDEUR"))) <–This formula currently works

G67 is basically check if what currency is listed. If EURO, then no conversion, else it convert to EURO.

Now I want to add an additional check where if there is NO ticker symbol in cell G3 this cell should remain blank. If the ticker symbol is there, then it should do exactly what my current formula does.

Any ideas how to alter the formula so it add this condition? I'm not very good with complexer formulas and not finding the solution is driving me crazy. : (

Best Answer

Since there are multiple conditions that should each lead to another type of result, you may want to try with the ifs() function, like this:

=ifs( 
  isblank(G3), iferror(1/0), 
  G67, G12, 
  true, G12 * googlefinance("CURRENCY:USDEUR") 
)
Related Topic