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