# Help with calculation

This topic is 6456 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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.

##### Share on other sites

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"

)

)

)

##### Share on other sites

Thank you so much for the help.

##### Share on other sites

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

##### Share on other sites

Try:

If (

CODE = "abc" or

CODE = "def" or

CODE = "ghi" ;

Total + qty * 8 ; Total

)

##### Share on other sites

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

##### Share on other sites

This topic is 6456 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,481 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,271 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,500 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,115 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,743 views
×
×
• Create New...