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. : (

  • I think Ticker symbol (Insert --> Checkbox) resolves to TRUE or FALSE in Google Sheets. So you can simply wrap your formula in an outer IF checking for TRUE (ticked) or FALSE (Unticked). – patkim May 8 at 1:52
  • Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there. – doubleunary May 8 at 15:41

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:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy