Add condition to formula to use column IF not Empty

Topic Labels: Formulas
178 1
Showing results for 
Search instead for 
Did you mean: 
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:

  {Fixed exchange rate},
  Value * {Fixed exchange rate},
  Value * {Forecasted exchange rate}