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!
Page 1 / 1
Hmm, does this look right?
If so, here's the formula:
IF(
{Fixed exchange rate},
Value * {Fixed exchange rate},
Value * {Forecasted exchange rate}
)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.