IF Formula in Numeric ( Selected Currency )
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 ...
Forum Discussion
try this
IF(
[Currency]="Euro", [qty]*[Price Euro],
[Currency]="AUD", [qty]*[Price AUD])
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
IF(
[Currency]="Euro", [qty]*[Price Euro],
[Currency]="AUD", [qty]*[Price AUD])
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thanks Mark,
I will try this one
------------------------------
Quickbase Admin
------------------------------
I will try this one
------------------------------
Quickbase Admin
------------------------------
