Skip to main content

Hello! I want to add something to the formula below. I want to add the condition that IF the column 'Fixed exchange rate' is not empty (there is a number filled in) THAN that number should be used BEFORE using the Forecasted exchange rate. IF the Column 'Fixed exchange rate' is EMPTY, than use forecasted exchange rate. Current Formula: IF(AND(   {(Hide) Weighted Historical Exchange Rate ⚙️}=0, {Bankbook historical exchange rate}=0),{Forecast exchange rate ⚙️},IF(AND({(Hide) Weighted Historical Exchange Rate ⚙️}=0, {Bankbook historical exchange rate}>0),{Bankbook historical exchange rate},{(Hide) Weighted Historical Exchange Rate ⚙️})) Thank you!

Hmm, does this look right?


If so, here's the formula:

IF(
{Fixed exchange rate},
Value * {Fixed exchange rate},
Value * {Forecasted exchange rate}
)

 

Reply


Terms & Conditions