Hi All,

I am new into calculation, I am wonder if someone can give me an idea how should I write this calculation

If country equal USA

Perform the following calculation

If the price is between 1 to 50 it cost 6.50

If the price is between 51 to 150 it cost 10.00

If the price is more than 151 it cost 15.00

Otherwise if country equal other

Perform the following calculation

If the price is between 1 to 50 it cost 15.00

If the price is between 51 to 150 it cost 20.00

If the price is more than 151 it cost 25.00

Thank you, any help will be appreciated.

Case(

not IsEmpty ( price );

Case(

country = "USA";

Case(

price ≤ 50 ; "6.50" ;

price ≤ 150 ; "10.00" ;

"15.00"

);

Case(

price ≤ 50 ; "15.00";

price ≤ 150 ; "20.00" ;

"25.00"

)

)

)

Thank you so much for the help.

Hi,

I am really confused with calculation,

How do I code the following

If any of the CODE equal “abc, def or ghi”

Calculate = total + (qty*8.00)

Otherwise show the total

Any help will be appreciated.

thank you

Try:

If (

CODE = "abc" or

CODE = "def" or

CODE = "ghi" ;

Total + qty * 8 ; Total

)

Thank you for the help, but it didn't work for what I was trying to do maybe I was not very clear because what I am trying to do is to find the record in a portal

with the Code_ID “ABC”, “CDE” and “FEG” and do the calculation of the quantity number found on (A1+A2+A3) * 8.00

any idea. thank you in advance