Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Add condition to formula to use column IF not Empty

Topic Labels: Formulas
621 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Airtable_admin
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1

Hmm, does this look right?

Screenshot 2024-02-22 at 1.00.15 PM.png
If so, here's the formula:

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