Skip to main content
Question

IF Formula in Numeric ( Selected Currency )

  • September 22, 2021
  • 0 replies
  • 166 views
Dear Expert, 

I Need some Help to solve my formula as below and I need to calculate Total Amount Price base on currency 

I have fields 
Currency : Multiple choice ( AUD, Euro ) 
qty : Numeric
Price AUD : Numeric
Price Euro : Numeric 
Exchange rate : Numeric 
Total Estimate AUD : Formula-Numeric   --> [qty]*[price AUD] 
Total Estimate Euro : Formula-Numeric   --> [qty]*[Price Euro]

Total Amount Price : Formula Numeric 
So my formula did not work as per text below , I am wondering what went wrong with this formula : 
If ([Currency]="AUD", [Total Estimate AUD],[Estimate Total AUD]*[Exchange rate], 
    [Currency]="Euro", [Total Estimate Euro],[Estimate Total Euro]*[Exchange rate]) 

However I get some error 
Help ? :)

------------------------------
Quickbase Admin
------------------------------
This topic has been closed for replies.

  • MannyDeLaCruz
  • Quickbase Staff
  • September 22, 2021
Hi There Quickbase Admin!

Happy to help with this one!

From what your formula reads:

If ([Currency]="AUD", [Total Estimate AUD],[Total Estimate AUD]*[Exchange rate],
     
--> This is saying to display the [Total Estimate AUD] field when the [Currency] field equals "AUD", ELSE (so if it equals "Euro" being that from your description, there are only two choices), it runs [Total Estimate AUD]*[Exchange rate]

[Currency]="Euro", [Total Estimate Euro],[Total Estimate Euro]*[Exchange rate])

--> This states a similar process, but for "Euro", so now there are two clashing conditions for the "Euro" selection.

Would you mind giving some detail as to what you are trying to achieve / display so I can better help troubleshoot the formula?

Thank you!

------------------------------
Manny De La Cruz
Customer Adoption Manager
Quickbase
------------------------------
Terms & ConditionsAccessibility statement