
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2024 06:12 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2024 09:01 PM
Hmm, does this look right?
If so, here's the formula:
IF(
{Fixed exchange rate},
Value * {Fixed exchange rate},
Value * {Forecasted exchange rate}
)
 
