2

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

2
  • 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, 2021 at 1:52
  • Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there. May 8, 2021 at 15:41

1 Answer 1

1

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") 
)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.